SYSDATE evaluation in Where Clause - Help
712780Jul 22 2009 — edited Jul 22 2009v1 is type date
v2 is type date
I'm trying to use a comparison of v1 or v2 with (select sysdate from dual) in the clause area of my select statement.
eg.,
Select yada...yada ..
from table-1 inner join table-2
on table-1.owner = table-2.owner
where something
and something else
and v1 = (select sysdate from dual)
or v2 = (select sysdate from dual)
and it won't work. No errors, just no data and I have some records with today's sysdate in v1 and some in v2 but not both.
Edited by: user8625304 on Jul 22, 2009 11:59 AM