title: how to convert a number into timestamp in oracle/sql
body: <p>how to convert a number into timestamp(6) in  oracle?
  ie convert 20131108 to 08-NOV-13 12.00.00.000000 AM or any format in timestamp(6).
  Thanks!</p>