1TO_CHAR( sysdate, 'YYYY-MM-DD' )
2
3/*TO_CHAR Format Specifiers
4
5YYYY 4-digit year
6YY 2-digit year
7MON Abbreviated month (Jan - Dec)
8MONTH Month name (January - December)
9MM Month (1 - 12)
10DY Abbreviated day (Sun - Sat)
11DD Day (1 - 31)
12HH24 Hour (0 - 23)
13HH or HH12 Hour (1 - 12)
14MI Minutes (0 - 59)
15SS Seconds (0 - 59)*/