--- In firebird-support@yahoogroups.com, "Todd Pinel"
<todd_pinel@y...> wrote:

> 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.

As a matter of fact, I have the book... but didn't thought on looking
that up... oops. Sorry for taking all your time. But thanks for the
responses!

>
> Todd.
>
>
>
> _____
>
> From: zifnabbe [mailto:zifnabbe@u...]
> 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]