i tend to pass all dates in to my queries via a function which puts the date
in to the usa format irrespective of the date time settings on the machine,
check out the FormatDateTime() function.

Pete

> If I switch to UK formats (after the machine reboot), I would
> expect to have
> to do:
>
> select * from people where birthday = '01/03/1990'
>
> And in fact, that's the query Delphi will spit out in my code, as all of
> it's DateToStr functions pay attention to Windows settings.