title: How to convert date to timestamp(DD-MON-YYYY HH24:MI:SS.FF format) in oracle?
body: <p>I tried below query but its not working</p>
  
  <pre><code>select 
      TO_TIMESTAMP(ColumnName(Data type Date), 'DD-MON-YYYYHH24:MI:SS.FF') 
  from TableName 
  where Changedate&gt;='01-Dec-2015'
  </code></pre>
  
  <p>*I need the result without AM/PM indication.
  Result will be 15-DEC-2015 15:16:42.045016</p>