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