Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

TO_CHAR(SYSDATE, MONTH DDSP)

SQL> SQL> SQL> SELECT TO_CHAR(SYSDATE, 'MONTH DDSP')   2  FROM DUAL; TO_CHAR(SYSDATE,'MONTH ---------------------- JUNE      NINETEEN SQL> SQL>