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 |
|
aakcse
Aged Yak Warrior
570 Posts |
 Posted - 2010-01-22 : 04:21:42
|
| Hi all,I have imported a tabel from sql 2005 to excel 2007, I am getting dates for some columns as '1/2/1900 12:00:00 AM'However when I do a select in sql it gives me '1900-01-01 00:00:00.000' which is right, why the date is getting changed in excel for only some columns, and the datatype for those columns is date only.Regards,aak |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-01-25 : 01:25:43
|
| The date you see at EXECL is actually 1 day more than the actual date. See here for more informationshttp://www.cpearson.com/excel/datetime.htmMadhivananFailing to plan is Planning to fail |
 |
|
|
|
|
|
Importing issue with excel