title: Convert oracle timestamp to DD-MM-YYYY
body: <p>Need help.</p>
  
  <p>I am trying to pull data from toad where the one column (EFFECTIVE_FROM) contains the date in timestamp dd/mm/yy hh:mi:ss:mmmAM e.g. (5/8/2015 2:14:19 PM) but i want that date in DD-MM-YYYY i.e. 08-May-2015</p>
  
  <p>I am using the below query</p>
  
  <p>Please Help</p>
  
  <pre><code>SELECT B.USER_NAME AS CREATED_BY, A.CREATION_DATE, C.USER_NAME, A.LAST_UPDATE_DATE, A.PFIZER_ITEMCODE, A.SYSTEM_ITEMCODE AS ORACLE_ITEM_CODE,
  A.ITEM_DESCRIPTION, A.BATCH_NUMBER, A.MFR_CODE, A.MFR_DESC AS MFR_DESCRIPTION, A.MFR_DATE, A.EXPIRY_DATE, A.EFFECTIVE_FROM  
  FROM xxdhl_pf_batch_pricing A,
       fnd_user B,
       fnd_user c
  where 1=1
  AND A.CREATED_BY = B.USER_ID
  AND A.LAST_UPDATED_BY = C.USER_ID
  AND A.SYSTEM_ITEMCODE = 'xx' AND A.BATCH_NUMBER = 'yy'
  </code></pre>