DATE in SQL

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 - 07:54:49 CDT