Mega Code Archive
Initcap(rtrim(to_char(sysdate, MONTH))) initcap(to_char(sysdate, DDSPTH))
SQL>
SQL> select initcap(rtrim(to_char(sysdate, 'MONTH'))) ||' ' || initcap(to_char(sysdate, 'DDSPTH'))
2 from dual;
INITCAP(RTRIM(TO_CHAR(SY
------------------------
June Nineteenth
SQL>
SQL>