Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Error converting UDB dates to SQL Server Datetime

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-13 : 08:52:35
shelly writes "I am migrating data from UDB / DB2 database to SQL Server.

I get the following error:

"Error converting data type DBTYPE_DBDATE to datetime"

An exlicit conversion of the date may be required -- but how?

Please help!!"

Jay99

468 Posts

Posted - 2002-03-13 : 09:12:29
your implementation will depend on the tools you are using to 'migrate' the data, but mostly likely it will involve the CONVERT or CAST functions ... just a guess. Post more about how you are migrating and at what step you are getting the error.


Jay
Go to Top of Page
   

- Advertisement -