Re: DATE in SQL

Probably Richard is right in his assumption, but if he's not (and for future questions) please provide the error message you're getting. Makes it easier to help.

regards,
Peter

"Richard Foote" <richard.foote_at_bigpond.com> schreef in bericht 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 .
> >
>
>
Received on Mon Jul 22 2002 - 08:33:25 CDT