Function not returning new date:
set SERVEROUTPUT ON
declare
v_date CONSTANT DATE := sysdate;
begin
IF v_date = TRUNC(SYSDATE+30) THEN
dbms_output.put_line('30 days');
ELSE
dbms_output.put_line('other');
END IF;
END;
returns:
other
DB version 11.2.0.2.0
Any idea why?
Thanks!