Reply to Message

YYYY-MM-DD with literal dates in SQL Server queries.

Saves a lot of heartache.

Oposite problem to yourself, usually caused by some twit in the UK with their date time set to US.

I've got tripped up a few times with auto conversions using the local environment, now I try to avoid it as all costs using explicit conversions where ever necessary.