DBTYPE_DBTIMESTAMP oracle error ?!?

• saustin

  Right there with Babe

  Points: 765

  More actions

  July 6, 2004 at 12:32 pm

  #162182

  Hi All,        Does anyone have a work-around or solution to the DBTYPE_DBTIMESTAMP error "Error converting data type DBTYPE_DBTIMESTAMP to datetime" you get when trying to retrieve an Oracle datetime field from SQL server? Am just trying to write a storedProcedure to grab it. Many thanks for any suggestions. Steve.

• vadba

  SSChampion

  Points: 11133

  More actions

  July 7, 2004 at 5:54 am

  #513618

  Seems like most of the time, this error is caused by Oracle dates that exceed the date range of SQL Server, which is 1/1/1753 to 12/31/9999.

  Review the following thread, maybe there is something there you can use:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=102722

   

• Bob Monahon

  Ten Centuries

  Points: 1282

  More actions

  July 7, 2004 at 6:15 am

  #513620

  We got this same problem using Access/ODBC to retreive an Oracle query result.  The only solution we found was on Oracle side: We changed the date to a character string in the Oracle query; then we converted it back to a date in MS Access.

  ---

  Regards,

  Bob Monahon

• saustin

  Right there with Babe

  Points: 765

  More actions

  July 7, 2004 at 6:59 am

  #513628

  Thanks for the reply Bob,

                                     Sticky situation here with having nulls in some of the date fields. Ultimately need to write a sql server stored procedure to access the oracle data. Was able to use openquery with sql analyzer and returned the data back perfectly. Just seeing if this works in a stored procedure now. Steve.