Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date
Probably because his professor told him it is not allowed.
"Chuck" <chuckh_at_softhome.net> wrote in message
news:Xns93F494A6433ADchuckhsofthomenet_at_130.133.1.4...
> "Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote in news:bjsv1v$n6oq0$1
> @uni-berlin.de:
>
> >
> > Hi!
> >
> > The Query
> > SELECT * FROM T_Test WHERE Start > '1.1.2002'
> > is running with the correct results.
> >
> > Using a date with time like
> > SELECT * FROM T_Test WHERE Start > '1.1.2002 1:00:01'
> > doesnt work.
> >
> > My problem is that i have to avoid any function like to_date etc.
>
> Out of curiosity, why can't you use to_date?
Received on Fri Sep 12 2003 - 13:38:01 CDT