Hi All,

I'm hoping someone can help me with an odd problem that has just appeared on my dev client system - Query Analyser, EM and ADO have all stopped recognising 'yyyy-mm-dd' as a valid date format! 'yyyymmdd' works fine, as does 'yyy-MMM-dd'.

Does anyone know if there is some kind of swicth/option that might have been flipped to cause this? It's definately client related, the same queries run fine on my colleague's machine

Cheers,

Chris





There are two secrets to success in this world:
1. Never tell everything you know

__________________
There are two secrets to success in this world:
1. Never tell everything you know

One possible cause is the setting of the DATEFORMAT to ydm. Try putting the date format back to YMD and your problem should go away:

SET DATEFORMAY YMD

For related questions about date formats:
http://www.sql-server-helper.com/tips/date-formats.aspx

SQL Server Helper
http://www.sql-server-helper.com

Or even Control Panel -> Regional Settings...