your conversion systax is wrong:
to_date('19 07 2002','DD MM YY')
should be
to_date('19 07 2002','DD MM YYYY')
SQL> select to_date('19 07 2002','DD MM YYYY') from dual;
TO_DATE('
19-JUL-02
"kondor" <kondor_at_wanadoo.fr> wrote in message
news:3D3C0099.4070100_at_wanadoo.fr...
> Hi,
> I want to execute a request that return me the rows where date is more
> recent than 2002-07-19 (19/07/2002 in french format) I try :
>
> select ARTID from ARTICLES a, PAGES p
> where a.PGID=p.PGID and
> a.PGVERSION=p.PGVERSION and
> p.PGDATEPUB > to_date('19 07 2002','DD MM YY')
>
> or :
>
> select ARTID from ARTICLES a, PAGES p
> where a.PGID=p.PGID and
> a.PGVERSION=p.PGVERSION and
> p.PGDATEPUB > date '19/07/2002'
>
> but It returns me an error.
>
> Can you help me ...
> THANKS .
>
Received on Mon Jul 22 2002 - 12:38:05 CDT