In Helen's book I read that FireBird determines the format of all number
date literals by the separator used.

So a period(.) would give you Non-US format meaning DD.MM.CCYY and when a
slash (/) is used it is US convention of MM/DD/CCYY

There are also many other Date literals recognized by FireBird. I think
getting a copy of Helens book is a must to answer these kind of questions.

Todd.



_____

From: zifnabbe [mailto:zifnabbe@...]
Sent: Wednesday, November 03, 2004 11:44 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: Delphi and Firebird




--- In firebird-support@yahoogroups.com, "Thomas Steinmaurer"
<ts@i...> wrote:

> > At the moment I query a table between date with the use of parameters.
> >
> > as in
> >
> > select *
> > from x
> > where A = :MyDate
> >
> > With the use of parameters, you just pas :MyDate as a Date and you
> > don't have to worry about the right formatting of the Date.
> >
> > Now, because of circumstances, I would like to not use parameters, but
> > I would like to create the sql code on the fly, as in
> >
> > select *
> > from x
> > where A = '2003/01/20'
> >
> > Is there a way to know the exact format to be used?
>
> There are quite a number of different date/time
> formats supported in Firebird.
>
> MM/DD/YYYY or DD.MM.YYYY are good candidates
> from many.

How do we know one which to use? Or does firebird autodetects it?

Thanks.








Yahoo! Groups Sponsor



ADVERTISEMENT

<http://us.ard.yahoo.com/SIG=12992jbio/M=315388.5543473.6613715.3001176/D=gr
oups/S=1705115386:HM/EXP=1099593867/A=2372354/R=0/SIG=12id813k2/*https:/www.
orchardbank.com/hcs/hcsapplication?pf=PLApply&media=EMYHNL40F21004SS> click
here



<http://us.adserver.yahoo.com/l?M=315388.5543473.6613715.3001176/D=groups/S=
:HM/A=2372354/rand=456412490>



_____

Yahoo! Groups Links

* To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

* To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com
<mailto:firebird-support-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



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