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 |
|
mmkrishna1919
Yak Posting Veteran
95 Posts |
 Posted - 2013-03-13 : 08:56:02
|
| Hi All,Currently my session setting is mdywhat all are formats are valid as per my session setting?i tried with 01-31-2013 (mm-dd-yyyy) valid (make sense)31-01-2013 (throws arithmetic overflow error) (make sense) because there is no 31st month.But when i tried with 2013-01-31 it is returning resultand when i tried with 2013-31-01 it is throwing over flow error message.How sql server intrepets this date based on session setting?Thanks... M.MURALI kRISHNA |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
|
|
|
Date Format issue