Oracle SQL Comparison

From: Graeme St. Clair (Graeme.St.Clair_at_hds.com)
Date: 01/19/05 

To: dbi-users@perl.org
Date: Tue, 18 Jan 2005 15:55:58 -0800

Oracle 8.1.
 
I'm finding that for a REQUEST_DATE value of 25-May-01:-
 
WHERE BLAH.REQUEST_DATE <= TO_DATE('25-MAY-01', 'DD-MON-YY')
 
yields nothing, while
 
WHERE BLAH.REQUEST_DATE >= TO_DATE('25-MAY-01', 'DD-MON-YY')
 
spits out the rows I want.
 
 
WHERE BLAH.REQUEST_DATE BETWEEN TO_DATE('25-MAY-01', 'DD-MON-YY')
    AND TO_DATE('26-MAY-01', 'DD-MON-YY')
 
also works, but BETWEEN 24 and 25 does not. At least it's consistent! Is
this normal, or am I experiencing some kind of rounding condition?
 
Rgds, GStC.