format date pl sql to_char code example Example: sql to char function with date SELECT TO_CHAR( sysdate, 'YYYY-MM-DD' ) FROM dual;