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