question

You can use SWITCHOFFSET to change time zones if you know the offset for the local time zone. If not, you can calculate that. The server I'm using is set to UTC, so in this example I'm first generating a date in US Eastern Standard Time to then demonstrate how to convert to UTC.

DECLARE @datetime DATETIMEOFFSET = CONVERT(datetimeoffset, SYSUTCDATETIME()) AT TIME ZONE 'US Eastern Standard Time';
DECLARE @offset char(6) = RIGHT(@datetime, 6);
SELECT @datetime, @offset, SWITCHOFFSET(SYSUTCDATETIME(), @offset);

The offset is a string in the format "-00:00". It appears at the end of any datetimeoffset string value. I hope this helps.

sorry I am new to sql … I am getting lot of errors, can you tell me what I am doing wrong?

Select A.[SCH_ALARM_SK], A.[NOM_DATE] Date_Integer, DATEADD(day, -2, A.[NOM_DATE]) Date, C.[ID], C.[SORT_NAME], B.DESCR,
DATEADD(mi, A.[START_FNMOMENT]/60, '12/30/1899 00:00:00') AS START,
DATEADD(mi, A.[RAISE_FNMOMENT]/60, '12/30/1899 00:00:00') AS STOP,
DATEADD(mi, A.[CLEAR_FNMOMENT]/60, '12/30/1899 00:00:00') AS CLEAR,
COALESCE(DATEDIFF(SS, DATEADD(mi, A.[START_FNMOMENT]/60, '12/30/1899 00:00:00'),
DATEADD(mi, A.[CLEAR_FNMOMENT]/60, '12/30/1899 00:00:00') ),0) AS DURation,
CONVERT(datetimeoffset, SYSUTCDATETIME()) AT TIMEZONE 'US Eastern Standard Time';
DECLARE @offset char(6) = RIGHT(@datetime, 6);
SELECT @datetime, @offset, SWITCHOFFSET(SYSUTCDATETIME(), @offset)
from [dbo].[SCH_ALARM_INST] A
Inner Join [dbo].[SCH_ALARM] B
ON A.[SCH_ALARM_SK] = B.[SCH_ALARM_SK]
Inner Join [dbo].[EMP] C
ON C.[EMP_SK] = A.[EMP_SK]
where DATEADD(day, -2, [NOM_DATE]) between '2018-06-08 00:00:00.000' and '2019-06-08 00:00:00.000'
and A.[SCH_ALARM_SK] IN ('-988632205052')