From oracle-l-bounce@freelists.org Wed Mar 3 09:17:15 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i23FHE700580 for ; Wed, 3 Mar 2004 09:17:14 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i23FHDo00572 for ; Wed, 3 Mar 2004 09:17:13 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C91E3394D04; Wed, 3 Mar 2004 10:15:27 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 03 Mar 2004 10:13:53 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from amcuxfw801.amc.af.mil (amcuxfw801.amc.af.mil [131.9.254.189]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 5CDBD3949A0 for ; Wed, 3 Mar 2004 10:13:46 -0500 (EST) Received: from amcw2av809.amc.ds.af.mil (amcw2av809.amc.af.mil [131.9.19.138]) by fw1.amc.af.mil with SMTP id i23FEmKu007563 for ; Wed, 3 Mar 2004 09:17:37 -0600 (CST) Received: from amcw2ms872.amc.ds.af.mil ([131.9.25.137]) by amcw2av809.amc.ds.af.mil (SAVSMTP 3.0.1.45) with SMTP id M2004030309173626701 for ; Wed, 03 Mar 2004 09:17:36 -0600 Received: from AMCW2VN801.amc.ds.af.mil ([131.9.19.50]) by amcw2ms872.amc.ds.af.mil with Microsoft SMTPSVC(5.0.2195.6713); Wed, 3 Mar 2004 09:17:36 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.0.6375.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C40132.A8C32B5B" Subject: RE: EPOCH date conversion? Date: Wed, 3 Mar 2004 09:17:36 -0600 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: EPOCH date conversion? Thread-Index: AcP/zxU/FipfE/28Q8iMyXq6LQlp9QBYu8AQ From: "Whittle Jerome Contr NCI" To: X-OriginalArrivalTime: 03 Mar 2004 15:17:36.0977 (UTC) FILETIME=[A9127C10:01C40132] X-archive-position: 163 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Jerome.Whittle@scott.af.mil Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C40132.A8C32B5B Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi Scott, You mean the CDate function in Access.=20 Debug.Print Format(CDate(0), "mm/dd/yyyy hh:mn") =3D 12/30/1899 00:00 Jerry Whittle ASIFICS DBA NCI Information Systems Inc. jerome.whittle@scott.af.mil 618-622-4145 > -----Original Message----- > From: Scott Graves [SMTP:scott.graves@mo.nisc.cc] > =20 > 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. > =20 > 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.=20 > =20 > Scott Graves > Sr. Systems Programmer > NISC RDQ-STP > Email: scott.graves@nisc.cc > Phone: 636-922-9122 x7616 > Fax: 636-922-2080 > =20 ------_=_NextPart_001_01C40132.A8C32B5B Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable RE: EPOCH date conversion?

Hi Scott,

You mean the CDate function in Access.

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

Jerry Whittle
ASIFICS DBA
NCI Information Systems = Inc.
jerome.whittle@scott.af.mil
618-622-4145

    -----Original = Message-----
    From:   Scott Graves [SMTP:scott.graves@mo.nisc.cc]
    =A0
    One of the 3rd party code managements systems = we use stores dates as numbers.=A0 The Access function ctime() will = correctly interpret the date into a valid date format via an ODBC = connection.=A0 I’m trying to duplicate this function in = sqlplus.=A0 They tell me that the value of =A038030.7181 equates to = 2/13/2004=A0=A0 5:14:06PM.

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

    =A0
    Scott = Graves
    Sr. Systems Programmer
    NISC RDQ-STP
    Email: scott.graves@nisc.cc
    Phone: 636-922-9122 x7616
    Fax: 636-922-2080
    =A0

------_=_NextPart_001_01C40132.A8C32B5B-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------