RE: EPOCH date conversion?

From: Whittle Jerome Contr NCI <Jerome.Whittle_at_scott.af.mil>
Date: Wed, 3 Mar 2004 09:17:36 -0600
Message-ID: <DFEC3C69DE8C524DA705BC09A220740B028C0FBE@AMCW2VN801.amc.ds.af.mil>

Hi Scott,

You mean the CDate function in Access.

Debug.Print Format(CDate(0), "mm/dd/yyyy hh:mn") = 12/30/1899 00:00

Jerry Whittle
ASIFICS DBA
NCI Information Systems Inc.
jerome.whittle_at_scott.af.mil
618-622-4145

> -----Original Message-----
> From: Scott Graves [SMTP:scott.graves_at_mo.nisc.cc]
>
> 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 Wed Mar 03 2004 - 09:17:15 CST