|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Change way datetime is stored in server express 2k5
Hi,
I'm using mssql server express 2005. I'm using DTS to transfer data directly from a .csv to my database, however, the datetime values aren't being stored properly. This is the output I get after the DTS is run... 2007-12-03 00:00:00 2007-12-03 01:00:00 2007-12-03 02:00:00 2007-12-03 03:00:00 2007-12-03 04:00:00 2007-12-03 05:00:00 2007-12-03 06:00:00 2007-12-03 07:00:00 2007-12-03 08:00:00 2007-12-03 09:00:00 2007-12-03 10:00:00 2007-12-03 11:00:00 2007-12-03 12:00:00 2007-12-03 13:00:00 2007-12-03 14:00:00 2007-12-03 15:00:00 2007-12-03 16:00:00 2007-12-03 17:00:00 2007-12-03 18:00:00 2007-12-03 19:00:00 2007-12-03 20:00:00 2007-12-03 21:00:00 2007-12-03 22:00:00 2007-12-03 23:00:00 2013-03-07 00:00:00 2013-03-07 01:00:00 2013-03-07 02:00:00 2013-03-07 03:00:00 2013-03-07 04:00:00 2013-03-07 05:00:00 2013-03-07 06:00:00 2013-03-07 07:00:00 2013-03-07 08:00:00 2013-03-07 09:00:00 2013-03-07 10:00:00 2013-03-07 11:00:00 2013-03-07 12:00:00 2013-03-07 13:00:00 2013-03-07 14:00:00 2013-03-07 15:00:00 2013-03-07 16:00:00 2013-03-07 17:00:00 2013-03-07 18:00:00 2013-03-07 19:00:00 2013-03-07 20:00:00 2013-03-07 21:00:00 2013-03-07 22:00:00 2013-03-07 23:00:00 2014-03-07 00:00:00 2014-03-07 01:00:00 2014-03-07 02:00:00 2014-03-07 03:00:00 2014-03-07 04:00:00 2014-03-07 05:00:00 All the dates should be 2007, but they aren't being stored properly in mssql. I'm using the ms sql server management studio express...Anyone know how i can change the way the dates are stored? Thanks a lot. |
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Change way datetime is stored in server express 2k5 |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|