Sql to char

This article is tagged with: Sql to char and mysql

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

sql to char function with date

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

This article is tagged with: Sql to char and mysql