RE: EPOCH date conversion?
- From: "Whittle Jerome Contr NCI" <Jerome.Whittle@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 3 Mar 2004 09:17:36 -0600
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@xxxxxxxxxxxx
618-622-4145
> -----Original Message-----
> From: Scott Graves [SMTP:scott.graves@xxxxxxxxxx]
>
> 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@xxxxxxx
> Phone: 636-922-9122 x7616
> Fax: 636-922-2080
>
Other related posts:
