sql to char
snippet in sql

sql to char function with date

user6946

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

sql to char

user6210

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)*/