When I query a table with a datetype field I get the date in european format (dd-mm-yy(yy)). However, whenever I try to make a selection using a comparison string in the WHERE clause like '22-09-2002' I get no results. When I change the string in the USA format (09-22-2002) it gives the expected results. Which config/installation setting governs this behaviour?

Thnx