How to compare a date to sysdate

From: ramdan <ramdan_at_mailexcite.com>
Date: 2 Mar 1999 15:35:04 -0600
Message-ID: <EPYC2.17500$F63.44210@newscene.newscene.com>

why does this not work?!!?!?

SQL> SELECT SYSDATE FROM DUAL; SYSDATE

---

02-mar-1999

SQL> select * from tab1row where readdate = (select sysdate from dual);

no rows selected

SQL> select * from tab1row where readdate = sysdate;

no rows selected

SQL> describe tab1row;

 Name                            Null?    Type
 ------------------------------- -------- ----
 NAME                                     VARCHAR2(10)
 READDATE                                 DATE
 READING1                                 NUMBER
 READING2                                 NUMBER
 READING3                                 NUMBER
 READING4                                 NUMBER

SQL> select * from tab1row;

NAME READDATE READING1 READING2 READING3 READING4 ---------- ----------- --------- --------- --------- ---------

TEST        04-mar-1999
system     04-mar-1999      1000      1500      2000      1400
system     04-mar-1999      1000      1500      2000      1400
test1        02-mar-1999

Received on Tue Mar 02 1999 - 15:35:04 CST