Please may we colonial Autralians use your date format too?
Supposedly you can change your language settings and it all
works. I am a little sceptical as I've just tried that, both on
the OS level ( Regional Settings ), and adding a user whose
language has the correct order dmy
( select * from master..syslanguages and pick one).
The only format I can get it to accept is yyyy-mm-dd, which was
my default setting before I started fiddling. I haven't rebooted,
but I have stopped and started sql a few times. If you see a
different format ( ...