Re: Date Comparison

From: Tim Cuthbertson <Tim.E.Cuthbertson_at_bridge.bst.bls.com>
Date: 1996/12/13
Message-ID: <32B16DC3.48DB@bridge.bst.bls.com>#1/1

The "date" you think you stored is more than just the date, it is a full datetimestamp. Your first comparison is looking for midnight on the date you stored. The second comparison is correctly retrieving the two rows where the datetimestamp is indeed greater than midnight on the date.

To get it to act the way you want, you need to either store the value as TRUNC(SYSDATE) or you need to compare WHERE TOCHAR(a,'DD-MM-YY').

You could look it up. Received on Fri Dec 13 1996 - 00:00:00 CST