Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

-

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