Re: Convert Number to Time ?

From: ???sta?t???? ?. ?apa???????? <konion2_at_yahoo.com>
Date: Sat, 25 May 2002 19:27:45 +0300
Message-ID: <acoh86$22su$1_at_ulysses.noc.ntua.gr>


You must find the programmer, because Oracle has only fields type of DATE which MS-SQL converts them automaticly to datetime

"Jon Spartan" <jonu_at_ixtech.net> wrote in message news:1v7oeuo9ul04d4m6p3ptoef507jm51h2go_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 Sat May 25 2002 - 18:27:45 CEST

Original text of this message