Convert Epoch Time in SQL Query

For MSSQL:

DATEADD(s, t_stamp/1000, '1970-01-01')