Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / SQL Data Types

 

DDSPTH of MONTH, YEAR A D

SQL> SQL> SELECT TO_CHAR(SYSDATE, 'DDSPTH "of" MONTH, YEAR A.D.')   2  FROM dual; TO_CHAR(SYSDATE,'DDSPTH"OF"MONTH,YEARA.D.') ---------------------------------------------------------------------------- THIRTY-FIRST of MAY      , TWO THOUSAND SEVEN A.D. SQL>