I had a webapp that executes this query:
.. where [Date] >= ’2010-05-28′ ..
Now I have setup all the system again and query doesn’t work.
So what’s up?
Query instead works with this where filter condition:
.. where [Date] >= ’2010-28-05′ ..
I thought date string was multilanguage, but that’s not the case.
Solution is here: http://msdn.microsoft.com/it-it/library/ms180878.aspx
Documentation says that ISO 8601 is not multilanguage, it means that query translates your date string based on the sql server instance language.
So for the future, do not use date string format language based!
