We have a pain-in-the-#@#%$^@!*( Oracle database ....that is linked to a SQL Server 2005 machine (not SQL 2008)
Need to insert rows into an #&$*!% Oracle table that has a table with datetime2 (timestamp field)
Inserting data to the entire row works fine, but cannot cover the darn datetime2 field.
Any ideas why everything fails?
Here is a sample query getting data from SQL Server and inserting into Oracle - via whatever the driver is in between
insert into stupidOracleTable (update_time_field)
SELECT top 1 convert(varchar(10),UPDATE_DATE,113) + 'T' + right(convert(varchar(19),UPDATE_DATE,126),8) + '.0000000' from DATE_SPAN
which is trying to insert this: 2011-02-11T22:06:23.0000000