Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

SELECT TO_CHAR(SYSDATE, DDMMYYYY)

2   FROM dual; TO_CHAR(SY ---------- 31/05/2007 SQL>