Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> DATE in SQL

DATE in SQL

From: kondor <kondor_at_wanadoo.fr>
Date: Mon, 22 Jul 2002 14:54:49 +0200
Message-ID: <3D3C0099.4070100@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 - 07:54:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US