Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Date comparison in WHERE clause

539132Oct 24 2006 — edited Oct 24 2006
I 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 21 2006
Added on Oct 24 2006
2 comments
307 views