Message-Id: <10605.115982@fatcity.com> From: Jeff Wiegand Date: Thu, 31 Aug 2000 10:15:21 -0500 Subject: 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 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 or something).