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 |
|
tan0420
Starting Member
3 Posts |
 Posted - 2013-01-01 : 23:16:41
|
My csv file show date is '1931-05-31', but when i import to MSSQL 2008 the table show me is '31-05-11'. I set the data type is 'date'. PLEASE HELP.THANKS |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-01-01 : 23:44:32
|
| is it a direct pull or have you applied any transformation?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
tan0420
Starting Member
3 Posts |
Posted - 2013-01-02 : 01:19:24
|
| no, i using "bulk insert" into table. |
|
|
|
|
|
|
Error date format when import csv into table