Date in dba_audit_trail

timestamp in DBA_AUDIT_TRAIL defined as

cast ((from_tz(ntimestamp#,'00:00') at local) as date)

extended_timestamp defined as

from_tz(ntimestamp#,'00:00') at local

More often you know dates in Database timezone. It’s better to use

extended_timestamp AT TIME ZONE DBTIMEZONE