/ Published in: SQL
![](/img/icon_sav.png?v3)
This Oracle SQL snippet converts an Oracle SQL DATE to a STRING in the form CCYYMMDD.
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
TO_CHAR(date1,'YYYYMMDD')
Comments
![RSS Feed for Comments RSS Icon](/images/rss.png?v3)
TO_CHAR(date1,'YYYYMMDD')