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 |
|
colmanmadden
Starting Member
1 Post |
 Posted - 2011-11-17 : 18:12:18
|
| I'm importing a date from a text file using SSIS. The date is in the format 22.07.2010 00:00:00. I'm doing a replace on the '.' with '-' and then doing a conversion to database date(DT_DBDATE).Works fine for 22nd september but for some like 10th march it will change it to 3rd of October. See results below:22-07-2010 00:00:00 TO 2010-07-22 00:00:00.00010-03-2009 00:00:00 TO 2009-10-03 00:00:00.000Any ideas how to fix this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-11-18 : 02:16:56
|
| thats because of date format. either set dateformat to dmy or pass dates in iso format 2009-03-10------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
SSIS date import