Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

To_char(sysdate,MONTH mon) as month

SQL> SQL> select to_char(sysdate,'MONTH mon') as month   2  from dual; MONTH ------------- JULY      jul SQL>