Convert Number to Time ?

From: Jon Spartan <jonu_at_ixtech.net>
Date: Thu, 23 May 2002 00:32:34 GMT
Message-ID: <068oeu8rr10n340e38m5klcjq7mhkvroe5@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 Wed May 22 2002 - 19:32:34 CDT