SQL problem with date types

From: <leonardra_at_my-deja.com>
Date: Fri, 08 Dec 2000 17:12:13 GMT
Message-ID: <90r4p7$pdo$1@nnrp1.deja.com>

If this is wrong forum, please let me know.

I'm having a problem doing selects with date type. I have two selects below and don't know why the second one doesn't work. If you know how to get it to work, let me know.

Thanks,
Bob Leonard

SQL> select create_date from USER_ADM_TBL where create_date > TO_DATE('06-DEC-2000','DD-MON-YYYY'); CREATE_DA

06-DEC-00
07-DEC-00
07-DEC-00
07-DEC-00
07-DEC-00

SQL> select create_date from USER_ADM_TBL where create_date = TO_DATE('07-DEC-2000','DD-MON-YYYY'); no rows selected

SQL> Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 08 2000 - 11:12:13 CST