Hi,

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

The SQL standard describes 'YYYY-MM-DD' and this works on almost every
database. Also on Firebird.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://80.126.130.81