Message-Id: <10648.119191@fatcity.com>
From: MTPConsulting@aol.com
Date: Fri, 13 Oct 2000 11:09:31 EDT
Subject: Re: [Q] ORACLE date select problem?

Use:

select account_id, datestamp from table1
    where datestamp < to_date('31-DEC-1996','DD-MON-YYYY');

Otherwise you are doing a character comparision -- that's why you get those 
results.  You have to do a date comparision. 

Marc Perkowitz
MTP Systems Consulting

In a message dated 10/13/00 9:44:21 AM Central Daylight Time, 
leed@chele.cais.net writes:

<< 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?