Convert UTC to Local Time Zone in SQL Server | AT TIME ZONE

 Select GetDATE();

Select GetUTCDATE(); Select SYSDATETIMEOFFSET(); --------------------------------------------------------------------- declare @dt datetime = '2022-08-23 08:47:05.693'; Select CASE WHEN @dt AT TIME ZONE 'INDIA STANDARD TIME' > getdate() AT TIME ZONE 'EASTERN STANDARD TIME' THEN 1 ELSE 0 END DTTIMEDIFF ----------------------------------------------------------------------------------- Select @dt AT TIME ZONE 'INDIA STANDARD TIME' AT TIME ZONE 'EASTERN STANDARD TIME'