| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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_01C0135E.47A64D00
Content-Type: text/plain;
charset="iso-8859-1"
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 or something).
------_=_NextPart_001_01C0135E.47A64D00
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>Date Conversion</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Hello List.</FONT>
</P>
<P><FONT SIZE=3D2>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:</FONT></P>
<P><FONT SIZE=3D2>964473249811</FONT>
<BR><FONT SIZE=3D2>964473412927</FONT>
<BR><FONT SIZE=3D2>964473649881</FONT>
<BR><FONT SIZE=3D2>964473659746</FONT>
<BR><FONT SIZE=3D2>964473882543</FONT>
<BR><FONT SIZE=3D2>964473915782</FONT>
<BR><FONT SIZE=3D2>964473972845</FONT>
<BR><FONT SIZE=3D2>966970660171</FONT>
</P>
<P><FONT SIZE=3D2>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 or something).</FONT></P>
Received on Thu Aug 31 2000 - 10:15:21 CDT
 |
 |