Date Timezone Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Date Timezone
  4. TO_CHAR(SYSDATE, MONTH DDTH)
SQL>
SQL> SELECT TO_CHAR(SYSDATE, 'MONTH DDTH')
  2  FROM DUAL;
TO_CHAR(SYSDAT
--------------
JUNE      19TH
SQL>