RE: Date Conversion

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Thu, 31 Aug 2000 11:43:19 -0400
Message-Id: <10605.115990@fatcity.com>

looks like these might be 1/100ths of a second since 1-Jan-1970 (00:00), you might try  

select to_date( to_date('1-jan-1970 00:00:00','dd-mon-yyyy hh24:mi:ss') + (col1/(100*24*60*60))) from table_A  

using this formula,
the first number below comes out as sometime on July 24th, 2000  

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com <Discussing an image of a black rectangle silhouetted against the Martian landscape> "That is the top of the calibration target, that is _not_ in fact

a monolith."
- NASA TV commentator, 7/5/97  

-----Original Message-----
From: Jeff Wiegand [mailto:jwiegand_at_ancept.com] Sent: Thursday, August 31, 2000 12:18 PM To: Multiple recipients of list ORACLE-L Subject: Date Conversion

Hello List.

We need to convert two columns in a table to date type. Currently, the two columns are Varchar2. This wouldn't be a problem if there were actual dates held in the columns. A Java application inserts into the table, and inserted in a format such as this:

964473249811
964473412927
964473649881
964473659746
964473882543
964473915782
964473972845
966970660171

Each one of those values represents a date. Is there a way to make sense of this? A way to convert this to a date value Oracle will recognize. One developer told me these are long date values (milliseconds since some date Received on Thu Aug 31 2000 - 10:43:19 CDT