I was kind off expecting SQL to throw an error due to regional settings. I am in South Africa and we specify the day before the month (the day is after all smaller than the month).
Are there any regional settings when this won't work?
It did throw a fault when I ran:
SELECT CAST('22/02/00' AS DATETIME)
which would be 'dd/mm/yy'.
Good question but SQL would throw an error it wasn't 02 February all the time.