RE: EPOCH date conversion?

From: Vergara, Michael (TEM) <mvergara_at_guidant.com>
Date: Mon, 1 Mar 2004 13:00:00 -0800
Message-ID: <791D0E1ECDECD04D89205F33806FC38701E91C4D@temmse06.tem.guidant.com>

I gaze into my crystal ball...it says you use Remedy! Right? Well, we do, and it has the same...er...feature.  

This...
SELECT ((86400 *

         ( to_date('&Enter_Date_and_Time','MM/DD/YY:HH24:MI') -
           to_date('01-JAN-1970'))) + 28800) newtime

FROM dual
/
...works for me. Somebody else here in the group showed it to me, so I am passing it along. The 28800 is the fudge factor to my time zone.  

Cheers,
Mike  

-----Original Message-----

From: Scott Graves [mailto:scott.graves_at_mo.nisc.cc] Sent: Monday, March 01, 2004 12:48 PM
To: Oracle-L
Subject: EPOCH date conversion?  

One of the 3rd party code managements systems we use stores dates as numbers. The Access function ctime() will correctly interpret the date into a valid date format via an ODBC connection. I'm trying to duplicate this function in sqlplus. They tell me that the value of 38030.7181 equates to 2/13/2004 5:14:06PM.  

I tried several of the date conversions in metalink that convert EPOCH dates, but was unable to get any to produce the desired results. If anyone has any ideas, I would greatly appreciate it.  

Scott Graves
Sr. Systems Programmer
NISC RDQ-STP
Email: scott.graves_at_nisc.cc
Phone: 636-922-9122 x7616
Fax: 636-922-2080  

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html


-----------------------------------------------------------------

Received on Mon Mar 01 2004 - 14:57:15 CST