Message-Id: <10605.115988@fatcity.com> From: "Jamadagni, Rajendra" Date: Thu, 31 Aug 2000 11:34:51 -0400 Subject: RE: Date Conversion This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C01361.0145E64C Content-Type: text/plain; charset="iso-8859-1" If you are sure they are microseconds ... this might will help you ..... following query yields ... "08-22-2000 18:57:40" as output. SELECT TO_CHAR(TO_DATE('01011970','mmddyyyy') + (966970660171/86400000), 'MM-DD-YYYY HH24:MI:SS') FROM dual; Raj ______________________________________________________ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com QOTD: Any clod can have facts, but having an opinion is an art ! Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. ------_=_NextPart_001_01C01361.0145E64C Content-Type: text/html; charset="iso-8859-1" Date Conversion

If you are sure they are microseconds ... this might will help you ..... following query yields ... "08-22-2000 18:57:40" as output.

SELECT TO_CHAR(TO_DATE('01011970','mmddyyyy') + (966970660171/86400000), 'MM-DD-YYYY HH24:MI:SS') FROM dual;

Raj

______________________________________________________
Rajendra Jamadagni              MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
QOTD: Any clod can have facts, but having an opinion is an art !
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.