Sunday, February 12, 2012

convert db2 timestamp to sql server datetime

can someone please supply some information to help with this??

I am moving data from db2 8.1 for windows. the dates in db2 are defined as timestamp. i want to convert these to sql server datetime format in sql server 2000 using dts and sql.

does anyone have examples or something??

any help would be greatly appreciated.Look here

http://weblogs.sqlteam.com/brettk/archive/2005/06/02/5528.aspx

No comments:

Post a Comment