Yak Posting Veteran
Posted - 03/13/2013 : 08:56:02
| Hi All,
Currently my session setting is mdy
what 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 result
and when i tried with 2013-31-01 it is throwing over flow error message.
How sql server intrepets this date based on session setting?