Further to the solutions above, SQL Server actually stores datetime types in a set, 8 byte format, regardless of the locale settings. Full details on in SQL Books on Line, but this article covers
most of the relevant points[
^]
A company I worked for used to continuously get problems with dates in
where
clauses as it was multi-national. We adopted the use of unambiguous formats to overcome the issues ... e.g. '12-FEB-2013' or '02-DEC-2013' depending on which one you meant.
We also had issues where our datetime literally was a datetime - i.e. included hours, minutes, seconds etc so things like
WHERE entryDate='12-FEB-2013'
would fail anyway. We got around that particular problem something like this ...
WHERE dateadd(dd, datediff(dd, 0, entryDate), 0) = '12-FEB-2013'
We got the formatting stuff from
this blog on sqlservercentral.com[
^]