This must be a joke. Obviously, MySQL doesn’t play nicely with localization: it shows the data in the prefered US dateformats (mm/DD/yyyy) but does not allow to use this localized format in the select/where condition. The following gives garbage.
select * from datehuh
where date >= ’10/11/05′ /* dateformat on server */
Has to be rewritten as:
select * from datehuh
where date >= ‘2005-10-11’ /* yyyy-mm-dd */
Go straight to hell thank you very much.