RE: [Q] ORACLE date select problem?

I tried this, still same.

On Fri, 13 Oct 2000, Gillies, Garry wrote:

> Hi L,
>
> The character string '21_JAN-98' IS less than the character string
> '31-DEC-96'.
> If you want a date compare try
>
> where datestamp < to_date('31-DEC-96','DD-MON-YY');
>
> Regards
>
> Garry
>
> -----Original Message-----
> From: L [mailto:leed_at_chele.cais.net]
> Sent: 13 October 2000 15:29
> Subject: [Q] ORACLE date select problem?
>
> On ORACLE 7.3.4 database, I tried to select date less than "31-DEC-96".
> the following statement does NOT work correctly:
>
> select account_id, datestamp from table1
> where to_char(datestamp,'DD-MON-YY') < '31-DEC-96';
>
>
> It still print date like '21_JAN-98'.
>
> Anyone can give me a hint?
>
>
> Thanks
>
> ++++++++++++++++++++++++++++++++++++
> All internet traffic to this site is
> automatically scanned for viruses
> and vandals.
> ++++++++++++++++++++++++++++++++++++
Received on Fri Oct 13 2000 - 10:00:41 CDT