querying using sysdate problem
609621Dec 1 2009 — edited Dec 1 2009Dear all,
When am selecting from a table by directly mentioning the date like below :
SQL> select count(*) from do_calls where tdate=sysdate;
COUNT(*)
----------
0
SQL> select sysdate from dual;
SYSDATE
-----------
01-DEC-2009
SQL> select count(*) from do_calls where tdate='01-dec-2009';
COUNT(*)
----------
124
tdate is a date column...
Why is that it is not returning values when implicitly mentioning the system date.
Please guide
Kai