Re: Date

From: Chuck <chuckh_at_softhome.net>
Date: 12 Sep 2003 18:36:46 GMT
Message-ID: <Xns93F494A6433ADchuckhsofthomenet@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:36:46 CDT