SQL Server AUDIT/event_time I am using SQL Server 2012 Audit and when I look through the captured events I can see that event_time does not show the correct time. Actually it shows 5 hours earlier than time on the server. Do you have any ideas how can I fix that ?
The audit data uses UTC time. See this link for suggestions to adjust your query.


SELECT DATEADD(mi, DATEPART(TZ, SYSDATETIMEOFFSET()), 'HERE goes your date')