When i do rt click properties on SQL server it says language spanish.
When i run a query :
select * from shifthistory where vfrom='2009-07-23 00:00:00'. i get an error.
but when i use
select * from shifthistory where vfrom='23-07-2009 00:00:00' It works.
If i just run select * from shifthistory
It give me a result of vfrom as '2009-07-23 00:00:00' but when i use this date in the where clause it errors.