Hi,

I just want to ask in your application are you using
the ibx component to connect to the firebird server or
a 3rd party component? if it is a 3rd party component,
where can i find it?

thanks.

--- zifnabbe <zifnabbe@...> wrote:

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

________________________________________________________________________
Yahoo! Messenger - Communicate instantly..."Ping"
your friends today! Download Messenger Now
http://uk.messenger.yahoo.com/download/index.html