Problem with where clause and date condition
I have a table with a date field and need to know if the last
date I inserted in the table where 20 minutes ago or more. My
query is something like:
select d from t where (d + (20/1440)) < sysdate
but it doesn't work!!, sysdate="2001-10-31 9:15 AM", d="2001-10-
31 9:13 AM", the result is the same as:
select d from t where d < sysdate
Does anybody can help me? is it valid to use date arithmetic in
the where clause? is it a bug?
Thank you