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 |
|
kapil.dalvi
Starting Member
1 Post |
 Posted - 2009-05-04 : 09:29:37
|
| I have table which column holding datatype = DATETIME.While saving data to this column I am making use of the format as mentioned below :CONVERT(DATETIME, @DateTimeVariable, 120).Everything was working fine, but recently the date saved in that column were not proper.The format which used is --> 2006-02-30 15:23:45.000 (YYYY-MM-DD), but the data got saved in YYYY-DD-MM ie.(2009-04-09 09:29:45.000) [4-Sept-09] which actually is (2009-09-04 09:29:45.000) [09-Apr-09] |
|
|
vijayisonly
Master Smack Fu Yak Hacker
1836 Posts |
Posted - 2009-05-04 : 10:35:58
|
| what "value"/"format of date" are you passing to the @DateTimeVariable variable? |
 |
|
|
|
|
|
SQL date time issue while saving data