0

I am using SQL Server 2012 Audit and when I look through the captured events I can see that even_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 ?

0

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')

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.