Subject Re: Newbie: Setting the Date format
Author Svein Erling
Hi Leslie!

--- In firebird-support@yahoogroups.com, "cdb4w"
<lwm317_ebayaccount@b...> wrote:
> Hi all,
>
> How do I tell firebird to interpret dates in DD/MM/YYYY format
> rather than MM/DD/YYYY when executing SQL statements.

You simply don't. Firebird accepts four formats (at least that I know
of), MM/DD/YYYY, DD.MM.YYYY, YYYY-MM-DD and DD-mmm-YYYY (the last one
using English abbreviations for month, I've never used it so it may be
the other way around) and I don't think you can change this. The
programs you write should take care of any further formatting. This
formatting issue has never caused me any problems, using (Delphi with
IBObjects) parameters and .AsDateTime everything works just great.

HTH,
Set