Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. TO_CHAR(SYSDATE, MONTH DDSPTH)
SQL>
SQL> SELECT TO_CHAR(SYSDATE, 'MONTH DDSPTH')
  2  FROM DUAL;
TO_CHAR(SYSDATE,'MONTHDD
------------------------
JUNE      NINETEENTH
SQL>
SQL>