Mega Code Archive
Categories
/
Oracle PLSQL
/
Date Timezone
INITCAP(RTRIM(TO_CHAR(SYSDATE, MONTH)))
SQL> SQL> SELECT INITCAP(RTRIM(TO_CHAR(SYSDATE, 'MONTH'))) || 2 ' ' || 3 LOWER(TO_CHAR(SYSDATE, 'DDTH')) 4 FROM DUAL; INITCAP(RTRIM( -------------- June 19th SQL> SQL>