Posted By

retry on 07/29/08


Tagged

sql Oracle dates


Versions (?)

Convert an Oracle SQL DATE to a STRING in the form CCYYMMDD


 / Published in: SQL
 

This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.

  1. TO_CHAR(date1,'YYYYMMDD')

Report this snippet  

You need to login to post a comment.