Conversion Functions Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. Conversion Functions
  4. To_char(sysdate,MONTH mon) as month
SQL>
SQL> select to_char(sysdate,'MONTH mon') as month
  2  from dual;
MONTH
-------------
JULY      jul
SQL>