Lutz Haake | Freelance Oracle Consultant

Use the sys_extract_utc() function to convert systi­mestamp to UTC before comparing ntimestamp#!

select * from sys.aud$
where ntimestamp# > sys_extract_utc(systimestamp) — interval ‘30’ minute;