Bringing a thread back from the dead but to help people that stumble accross this page in the future

you could use the sql system function msdb.dbo.agent_datetime(run_date, run_time) to calculate the...