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



Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com