I'm trying to create a report of jobs that have closed within the last 60 days. It is a report that will get run on a monthly basis so the end date can't be a hard coded value.
Does anyone know how to get something similar to this:
select end_date, end_date - (to_number(substr(tz_offset( DBTIMEZONE ),2, 2))/24) as ActualTimeMinus from jtx.jtx_jobs where jtx.jox.jobs.end_date in (sys:cur_date - 60)
into the report manager sql view?
Any other suggestions?