Convert Epoch milliseconds as used by Javascript Date object and Unix timestamps to Local Standard Time via T-SQL for SQL Server

flux-convert-epoch-milliseconds-to-local-standard-time-sql-server.sql

declare @epochMilliseconds bigint
set @epochMilliseconds = 1530769196903

declare @utcDateTime datetime

select @utcDateTime = DATEADD(MS, @epochMilliseconds%(3600*24*1000), DATEADD(DAY, @epochMilliseconds/(3600*24*1000), '1970-01-01 00:00:00.000'))
--The result is 2018-07-05 05:39:56.903

select CONVERT(datetime, SWITCHOFFSET(@utcDateTime, DATEPART(TZOFFSET, @utcDateTime AT TIME ZONE 'AUS Eastern Standard Time'))) AS [AUS Eastern Standard Time]
--The result is 2018-07-05 15:39:56.903