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