Characters that allow you to separate the aspects of a date and time.You can supply freeform text in quotes as a separator. SQL>SQL> SELECT TO_CHAR(SYSDATE, 'DD-MM-YYYY') 2 FROM dual;TO_CHAR(SY----------31-05-2007