Hello,

> 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 US format:
MM/DD/YYYY

But: why?


With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com