Originally posted by polaris_ws
If you know how to format 'dd-Mon-yyyy' to 'mm/dd/yyyy' in Oracle. Show me your approach.
Thanks.
Code:
SQL> select to_char(sysdate, 'fmDD-MON-RRRR') from dual;

TO_CHAR(SYS
-----------
28-JAN-2003

SQL> select to_char(sysdate, 'fmmm/dd/rrrr') from dual;

TO_CHAR(
--------
1/28/2003

SQL> select to_char(sysdate, 'mm/dd/rrrr') from dual;

TO_CHAR(SY
----------
01/28/2003