How to convert UTC date time
[CreationDateLocal] = DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), cs.[CreationDate]) -- convert UTC to local time
{{ message }}
[CreationDateLocal] = DATEADD(MINUTE, DATEDIFF(MINUTE, GETUTCDATE(), GETDATE()), cs.[CreationDate]) -- convert UTC to local time