Date Comparison

Could someone please explain this to me:

Create table dummy (a date);

Insert into dummy values (sysdate);
Insert into dummy values (sysdate);
Commit;

Select * from dummy;
10-DEC-96
10-DEC-96 Select * from dummy where a = '10-DEC-96'

0 rows selected

Select * from dummy where a > '10-DEC-96' 10-DEC-96
10-DEC-96
2 rows selected

Why do I not get 2 rows returned when I try the select * from dummy where a = '10-DEC-96' ? I realize I can do a "less than 11-DEC-96 and greater than 10-DEC-96" but it seems like I shouldn't have to do all of that typing.

Thanks in advance Received on Thu Dec 12 1996 - 00:00:00 CST