hai provato con


SELECT DATEADD(ss, UnixTimeStamp, '01-01-1970 00:00:00.000') FROM myTabella

???