When I select data from Oracle to SQL Server via linked server I get exception
SELECT CreationDate FROM OPENQUERY (ORCLS, 'Select CreationDate from ADMIN.CV_TMP_Subscrs_Stage4_List')
Msg 8114, Level 16, State 8, Line 7 Error converting data type DBTYPE_DBTIMESTAMP to datetime.
If I cast date field in Oracle to varchar, reconvert it to datetime in sql server and fetch data I see
As far as I understand, Oracle formats date as "dd.MM.yyyy". In order to SQL Server to understand that I need to:
- Convert all date/datetime fields in queries to varchar
- Reconvert varchar to datetime in sql server side with specific format.
Seems like shooting cannon at sparrows. Maybe there is an easier way?