Convert Number to Time ?
From: Jon Spartan <jonu_at_ixtech.net>
Date: Thu, 23 May 2002 00:32:34 GMT
Message-ID: <n68oeu8b4rjefhrtgrmclh92ojfsk25msm_at_4ax.com>
[Quoted] 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.
Date: Thu, 23 May 2002 00:32:34 GMT
Message-ID: <n68oeu8b4rjefhrtgrmclh92ojfsk25msm_at_4ax.com>
[Quoted] 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.
[Quoted] I have to convert this to an MS-SQL datetime column.
[Quoted] 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:34 CEST