Re: DATE in SQL

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 22 Jul 2002 23:07:09 +1000
Message-ID: <YkT_8.41305$Hj3.123974@newsfeeds.bigpond.com>

Hi Kondor

select ARTID from ARTICLES a, PAGES p
where a.PGID=p.PGID and
a.PGVERSION=p.PGVERSION and
p.PGDATEPUB > '19/07/2002'

assuming dd/mm/yyyy is your default date format.

p.PGDATEPUB > to_date('19/07/2002', 'DD/MM/YYYY')

will always work as well.

Regards

Richard

"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 - 08:07:09 CDT