Date comparison in WHERE clause
539132Oct 24 2006 — edited Oct 24 2006I have this simple SQL sequence:
CREATE TABLE t1 (d1 DATE);
INSERT INTO t1 VALUES(CURRENT_DATE);
SELECT * FROM t1 WHERE d1 = CURRENT_DATE;
It is obvious what it does, yet on Oracle 10g R1 the SELECT query does not return anything. Any ideas on why this happens?
Thanks,
Robert