Strange sql error after migrating to a new laptop

On Windows Seven (32 bit) and Sql Server Express 2008 (32 bit)

I successfully run a query like this:

SELECT * FROM tblEmballagesScheduling WHERE StartDate <= '2011/03/14'

Today, I bought a new laptop with Windows Seven (64 bit) and installed Sql Server Express 2008 (64 bit) and I got the error below for the same query:

Msg 242, Leve开发者_如何学Cl 16, State 3, Line 1

La conversion d'un type de données varchar en type de données smalldatetime a créé une valeur hors limites.

English translate:

The conversion of a varchar data type to a smalldatetime data type resulted in an out-of-range smalldatetime value.

I don't know what's wrong ??

Thanks in advance for your help.

---

Can you try and see if this query works??

SELECT * FROM tblEmballagesScheduling WHERE StartDate <= '20110314'

I'm using the ISO-8601 date format (YYYYMMDD - or YYYY-MM-DDTHH:MM:SS), which is language independent and works will all regional and data format settings in SQL Server.

---

It's the localization setting. The setting your laptop now has set is in the format YYYY/dd/mm, and there is no month 14.

---

Based n the fact that you're reporting the error message in a foreign language, is it possible that the date format '2011/03/14' doesn't match your localization settings?

---

Uninstalling the french version of Sql Server Express 2008 then installing the english version of Sql Server Express 2008. Then the query with date fields are correctly interpreted (year/month/day).