T-SQL IsDate Function and Locale

[Gumbo Robot]

I'm trying to determine if a string represents a valid date.

So, IsDate('01/01/15') returns 1 as expected. IsDate('30/01/15') returns 0 even though it's a valid date.

I'm guessing the locale of the server is US & that's why IsDate is returning 0.

Is there a simple fix to this? I can't change locale or anything like that though.....

[WTFH]

You need to do it in Style.

Style 3 = dd/mm/yy

Or, LMGTFY: http://www.sqlservercentral.com/Foru...671-392-1.aspx

[ASB]

Where is the input coming from and is its format known ?

It will assume the locale as that in the db as far as I am aware unless told otherwise (which probably needs a convert or cast).

01/02/03 could mean many different things.

Might help:

https://msdn.microsoft.com/en-us/library/ms187928.aspx
SQL Datetime Conversion - String Date Convert Formats - SQLUSA

[Gumbo Robot]

SET DATEFORMAT = 'dmy' seems to have fixed it.

Thanks.