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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-09 : 22:50:13
|
Czarina writes "Hi. I'm in the process of extracting data from DB2 to SQL 2000 via DTS. I'm having a problem in extracting a datetime field. the source datetime has 6 digit (YYYY/MM/DD HH:MM:SS ffffff tt) milleseconds and if i read it correctly, SQL Server datetime can recognize up to 3 digit milleseconds (YYYY/MM/DD HH:MM:SS fff tt) only. The source datetime field is part of the index that makes the row unique. But since SQL only recognizes 3 digit milleseconds, i'm having duplicates in the data that i have extracted. Any help will be greatly appreciated.
thank you.
Czarina" |
|
|
|
|
|
Date Time Format