Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DATE in SQL
kondor wrote:
> 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 .
To format a date use TO_CHAR.
Daniel Morgan Received on Mon Jul 22 2002 - 10:48:07 CDT