You'll need to find out what the numbers mean. It may be simply the elapsed
time in seconds since a certain date or it may be something else. We have an
app that has a 'date' columns that is calculated as 8*day number + 64*month
number + 256*year The only way to convert is to find out what the algorithm
for converting dates into numbers is in the app that talks to this database.
Once you have done that, and verified the conversion, of course you can
shoot the developer for using the wrong datatype.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Jon Spartan" <jonu_at_ixtech.net> wrote in message
news:a58oeu4quio3817du088vpsk4k6gga41hn_at_4ax.com...
> I have an Oracle 8.1.7 DB I must work with and import into MS-SQL. The
> "programmer" has a column TIME ( which I will allow should be some for
> od time or date/time ) which is listed as "number" with a precision of
> 21.
>
> I have to convert this to an MS-SQL datetime column.
>
> Is there anyone who may assist me in this, as I am at a total loss as
> Oracle is very new to me ( 4 days and counting )
>
> Many thanks in advance
>
> Jon Spartan
>
Received on Thu May 23 2002 - 08:17:07 CDT
