Re: date problem

"charlie" <chartek_1_at_hotmail.com> wrote in message news:85866a8d.0308260808.7411b4ee_at_posting.google.com...
> Hi,
>
> Oracle 8.1.7
> Windows 2000 Server
> Using Sql Plus.
> nls_date_format = DD-MON-YYYY - I have tried using RRRR (below), YYYY,
> to_date and a number of different combinations, but always get the
> same results.
>
> First the query;
> select date_to from AGRPROD_CWaemserviceoff
> where to_char(date_to, 'DD-MON-RRRR') >= '24-AUG-2003'
> /
>
>
> Any ideas on why certain records aren't getting filtered?

Charlie

Your where clause comparison ">=" is being used to compare 2 strings. You should compare your stored date with a string converted to a date.

HTH eric

--
Remove the dross to contact me directly