OraFAQ Forum: SQL & PL/SQL » How convert NUMBER to DATE

Home » SQL & PL/SQL » SQL & PL/SQL » How convert NUMBER to DATE

Wed, 28 August 2002 22:15

IVP
Messages: 1
Registered: August 2002

Junior Member

How convert NUMBER to DATE

Thu, 29 August 2002 04:23

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

SQL> select to_date('08-29-02','mm-dd-yy') from dual;

TO_DATE('
---------
29-AUG-02

Previous Topic:	Executing a sql script in the command prompt and getting the output in a file
Next Topic:	Date Calculations/Averages sql

Goto Forum:

]

Current Time: Wed Apr 24 22:54:11 CDT 2024