RE: Date Conversion

From: Jamadagni, Rajendra <rajendra.jamadagni_at_espn.com>
Date: Thu, 31 Aug 2000 11:34:51 -0400
Message-Id: <10605.115988@fatcity.com>

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"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Date Conversion</TITLE>

<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>
<BODY>
<DIV>
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<FONT

color=#0000f0>(</FONT><FONT color=#000000>TO_DATE</FONT><FONT 
color=#0000f0>(</FONT><FONT color=#ff0000>'01011970'</FONT><FONT 
color=#0000f0>,</FONT><FONT color=#ff0000>'mmddyyyy'</FONT><FONT 
color=#0000f0>)</FONT><FONT color=#000000> </FONT><FONT 
color=#0000f0>+</FONT><FONT color=#000000> </FONT><FONT 
color=#0000f0>(</FONT><FONT color=#800000>966970660171</FONT><FONT 
color=#0000f0>/</FONT><FONT color=#800000>86400000</FONT><FONT 
color=#0000f0>),</FONT><FONT color=#000000> </FONT><FONT 
color=#ff0000>'MM-DD-YYYY HH24:MI:SS'</FONT><FONT color=#0000f0>)<SPAN 
class=415273315-31082000> </SPAN>FROM</FONT> dual<SPAN 
class=415273315-31082000>;</SPAN></P>

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. </DIV></BODY></HTML> Received on Thu Aug 31 2000 - 10:34:51 CDT