From oracle-l-bounce@freelists.org Mon Mar 1 14:47:41 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i21KlfE03789 for ; Mon, 1 Mar 2004 14:47:41 -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 i21Kleo03784 for ; Mon, 1 Mar 2004 14:47:40 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 1D42F394E31; Mon, 1 Mar 2004 15:48:23 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Mon, 01 Mar 2004 15:47:12 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from rams.nisc.cc (mail.cadp.org [12.10.126.154]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 24E3039490A for ; Mon, 1 Mar 2004 15:47:10 -0500 (EST) Received: from mofw1 ([12.10.126.135] helo=sgraves1) by rams.nisc.cc with smtp (Exim 3.16 #1) id 1AxuN2-0000DY-00 for oracle-l@freelists.org; Mon, 01 Mar 2004 14:50:36 -0600 From: "Scott Graves" To: "Oracle-L" Subject: EPOCH date conversion? Date: Mon, 1 Mar 2004 14:48:00 -0600 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006D_01C3FF9C.312E6110" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0) X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Importance: Normal X-Scanner: exiscan *1AxuN2-0000DY-00*nfzfIwmfb7g* X-archive-position: 172 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: scott.graves@mo.nisc.cc Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------=_NextPart_000_006D_01C3FF9C.312E6110 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 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@nisc.cc Phone: 636-922-9122 x7616 Fax: 636-922-2080 ------=_NextPart_000_006D_01C3FF9C.312E6110 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

 

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.

 <= /p>

Scott = Graves<= /p>

Sr. Systems = Programmer<= /p>

NISC RDQ-STP<= /p>

Email: = scott.graves@nisc.cc<= /p>

Phone: 636-922-9122 = x7616<= /p>

Fax: = 636-922-2080<= /p>

 <= /p>

------=_NextPart_000_006D_01C3FF9C.312E6110-- ---------------------------------------------------------------- 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 -----------------------------------------------------------------