Subject | Re: Newbie: Setting the Date format |
---|---|
Author | Svein Erling |
Post date | 2003-10-09T06:41:44Z |
Hi Leslie!
--- In firebird-support@yahoogroups.com, "cdb4w"
<lwm317_ebayaccount@b...> wrote:
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
--- In firebird-support@yahoogroups.com, "cdb4w"
<lwm317_ebayaccount@b...> wrote:
> Hi all,You simply don't. Firebird accepts four formats (at least that I know
>
> How do I tell firebird to interpret dates in DD/MM/YYYY format
> rather than MM/DD/YYYY when executing SQL statements.
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