Subject Re: [firebird-support] Re: Newbie: Setting the Date format
Author Tim Ledgerwood
I don't know what OS you are using, but in windows, whatever is displayed
(as opposed to whatever is stored) depends on your regional settings.

I understand that (again, however it is actually stored), FB accepts
several different date formats. In my case, I am using Delphi as a
development tool for the client side GUIs, so what I display to the user is
not related to what is stored in the database.

In order to force a certain date format before I post to the DB, I call
SetShortDateFormat or a similar procedure; but I find that I seldom have to
worry about that. If I have to pass an SQL string containing a date to some
query object, then generally I will build the string, making sure that the
date is in the format 'DD-MMM-YYYY' (e.g., '09-OCT-2003') which I have
found is accepted by all SQL servers that I have used.

All my applications use DD/MM/YYYY format.

Hope this helps,



At 08:56 AM 09/10/2003 +0000, you wrote:

>Hi Sven,
>Thanks for the reply which is pretty bad news. Many many countries
>use DD/MM/YYYY as standard and I find it incredible that this is not
>a valid format.
>--- In, "Svein Erling"
><svein.erling.tysvaer@k...> wrote:
> > Hi Leslie!
> >
> > --- In, "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
> > of), MM/DD/YYYY, DD.MM.YYYY, YYYY-MM-DD and DD-mmm-YYYY (the last
>To unsubscribe from this group, send an email to:
>Your use of Yahoo! Groups is subject to
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (
>Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003

[Non-text portions of this message have been removed]