| Subject | Re: [firebird-support] Re: Newbie: Setting the Date format |
|---|---|
| Author | Tim Ledgerwood |
| Post date | 2003-10-09T09:15:18Z |
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,
Regards
Tim
At 08:56 AM 09/10/2003 +0000, you wrote:
(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,
Regards
Tim
At 08:56 AM 09/10/2003 +0000, you wrote:
>Hi Sven,[Non-text portions of this message have been removed]
>
>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.
>
>Leslie.
>
>--- In firebird-support@yahoogroups.com, "Svein Erling"
><svein.erling.tysvaer@k...> wrote:
> > 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
>
>
>
>
>To unsubscribe from this group, send an email to:
>firebird-support-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003