‘Date’ and ‘Event Time’ columns in an Audit log in SQL Server are displayed in UTC

When you open an Audit Log, you may notice that the values for the Date and Event Time columns for the events that just occurred are different from the current Local time (if your Local time has time offset from UTC time):

Date and Event Time columns in an Audit log in SQL Server are displayed in UTC.

To see your current time offset from UTC time run this code:

SELECT DATEDIFF (hh, GETUTCDATE(), GETDATE())

To get the Local time from UTC time, add your time offset to the UTC time:

DECLARE @UTC_time datetime
SELECT @UTC_time = GETUTCDATE()
SELECT @UTC_time AS 'UTC Time'
,DATEADD(hh, DATEDIFF (hh, GETUTCDATE(), GETDATE()), @UTC_time) AS 'Local Time'

This simple code adds your current time offset to the UTC time, it is not applicable to old dates which have a different offset due to Daylight saving.