Re: webdb and Dates

Hello,
I wonder if the format specification requires you to do the comparisons on the TO_CHAR(...) of the date columns? The format specification would cause the Oracle native date format in the result set to be lost.

Regards,
Mark
mao_at_dde.dk

cat33dog_at_my-deja.com wrote:

> Hi
>
> I am trying to create a report using dates
> between to dates fromDate and toDate
>
> I create the report using an SQL statement
>
> to get the correct record I use ...date between fromDate and toDate ...
>
> In the column formatting I set the FORMAT MASK to MM/DD/YYYY
>
> in the parameter I set the values to 01/01/1990 and 01/01/2000
>
> I keep recieving an invalid date error message.
>
> What am I doing wrong/ Can I use hours and minutes in the format mask as
> well
>
> Thanks
>
> Patrick
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Wed Aug 11 1999 - 10:29:19 CEST