As Of Date in Oracle SQL - Back to the Future

This works:

select *
from
   (select * from ps_job where emplid = '123')
AS OF TIMESTAMP SYSDATE - 1;