RE: Converting a Number to a Date

From: David Barbour <DBarbour_at_connectsouth.com>
Date: Wed, 14 Jun 2000 16:59:43 -0500
Message-Id: <10528.109325@fatcity.com>

Thanks to everybody that responded. Rajendra's solution works like a charm!

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com

-----Original Message-----
From: Jamadagni, Rajendra [mailto:rajendra.jamadagni_at_espn.com] Sent: Wednesday, June 14, 2000 3:23 PM
To: 'ORACLE-L_at_fatcity.com'
Cc: 'DBarbour_at_connectsouth.com'
Subject: RE: Converting a Number to a Date

select to_char(to_Date('01011970', 'mmddyyyy') + (960770731/86400), 'MM-DD-YYYY HH24:MI:SS')
from dual
SQL> /   TO_CHAR(TO_DATE('01

---

06-12-2000 00:45:31  

HTH
Raj

---

Rajendra Jamadagni MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. Received on Wed Jun 14 2000 - 16:59:43 CDT