Re: Date

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 12 Sep 2003 21:43:45 +0200
Message-ID: <ec84mvceacoj4f13smja7fk590jkcchq8p@4ax.com>

On Fri, 12 Sep 2003 19:14:24 +0200, "Ralf Schnickmann" <ralf_schnickmann_at_gmx.de> wrote:

>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.
>
>Thanks,
>Ralf
>

First of all blank and imprecise statements like 'doesn't work' won't get you any adequate answers.
Secondly why on earth can't you use to_date? And if you can't use to_date you are aware you can alter session set nls_date_format?

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Sep 12 2003 - 14:43:45 CDT