Home -> Usenet -> comp.databases.oracle -> Convert Number to Time ?

Convert Number to Time ?

From: Jon Spartan <jonu_at_ixtech.net>
Date: Thu, 23 May 2002 00:32:32 GMT
Message-ID: <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 Thu May 23 2002 - 02:32:32 CEST












Original text of this message