advanced code snippet search

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.

Expand | Embed | Plain Text 
  1. TO_CHAR(date1,'YYYYMMDD')

Report this snippet  

You need to login to post a comment.