Re: Date
From: Chuck <chuckh_at_softhome.net>
Date: 12 Sep 2003 18:36:46 GMT
Message-ID: <Xns93F494A6433ADchuckhsofthomenet_at_130.133.1.4>
Date: 12 Sep 2003 18:36:46 GMT
Message-ID: <Xns93F494A6433ADchuckhsofthomenet_at_130.133.1.4>
[Quoted] "Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote in news:bjsv1v$n6oq0$1 _at_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 - 20:36:46 CEST