i have a problem with the isdate function , when i run it with the string Select isdate('201212') i get the result 1 But with Select isdate('201301') i get 0 , it seams like the date table of sql in not updated and any value above 201212 get 0.
SQL Server is interpreting the data in the dd/mm/yy with a two-digit year (dateformat = dmy). So obviously month = 13 is not a valid date. This MSDN page has information on setting the format: http://msdn.microsoft.com/en-us/library/ms189491.aspx
If you are trying to write a literal for January 2013, use '20130101'. That will give you January 1, 2013.
i have a problem with the isdate function , when i run it with the string Select isdate('201212') i get the result 1 But with Select isdate('201301') i get 0 , it seams like the date table of sql in not updated and any value above 201212 get 0.
isdate
Posted - 01/20/2013 : 04:05:55
