Error With SQL Standard Date

Hi

Playing around on server at new giggerooo.


SELECT CAST('2007-01-28'ASDATETIME)
throws:

Msg 242, Level 16, State 3, Line 1
The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.

This:

SELECT CAST('20070128'ASDATETIME)
Works fine.

ASFAIK (or recall) former is SQL Standard, latter is ISO.

Should I just start using the ever-so-slightly-less-readable YYYYMMDD format or is there a specific setting I should be looking at and perhaps change?

SS 2K
Language: English (United States)
Collation: Latin1_General_CI_AI

Ta
:)