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