Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DATE in SQL
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:YkT_8.41305$Hj3.123974_at_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 .
> >
>
Richard,
You are of course absolutely correct, but in common with other posters I would always recommend developers to use to_date explicitly rather than rely on any default.
kondor wrote:
> to_date('19 07 2002','DD MM YY')
Try YYYY.
Regards,
Paul
Received on Mon Jul 22 2002 - 14:28:28 CDT