oracle date time format code example

Example 1: sql to char

TO_CHAR( sysdate, 'YYYY-MM-DD' )

/*TO_CHAR Format Specifiers

YYYY			4-digit year
YY				2-digit year
MON				Abbreviated month (Jan - Dec)
MONTH			Month name (January - December)
MM				Month (1 - 12)
DY				Abbreviated day (Sun - Sat)
DD				Day (1 - 31)
HH24			Hour (0 - 23)
HH or HH12		Hour (1 - 12)
MI				Minutes (0 - 59)
SS				Seconds (0 - 59)*/

Example 2: sql to char function with date

SELECT
  TO_CHAR( sysdate, 'YYYY-MM-DD' )
FROM
  dual;

Example 3: specific date format oracle

TO_CHAR (TO_DATE('0297','MM/YY'), 'MM/YY')

Example 4: date format in oracle

e.g., 01-JAN-17