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 - 2004-11-29 : 05:08:08
|
| Sue writes "I would like to import some data into SQL 2000. This data resides on an AS400 and I connect to it using an ODBC datasouce. We can connect using Access/Excel/Crystal using the same datasource, no problem.If I import data that includes a date/time field, SQL does not seem to be able to handle it. It has no problem importing data that does not include a date/time field.The date/time field on the AS400 is set as a UTC date field.Is there any way I can import this UTC date into SQL?RegardsSue" |
|
|
|
|
|
UTC Dates in SQL