i have a table in oracle 11
I am running this sql to find if a task was created 4 or more days earlier than today's date..
select * from mytasks a where TRUNC(sysdate) - TRUNC(a.task_created_date) >= 4
Is that sql ok to use to find tasks created 4 days earlier than today's date... Or do I have to set any oracle-environment-variables to make sure it will work in that way...
Will the subtraction - "TRUNC(sysdate) - TRUNC(a.task_created_date) " will always result in "Days"