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?

Thanks.