Convert from Unix timestamp

Select
dateadd(S, [unixtime], '1970-01-01')
From [Table]

Source http://stackoverflow.com/questions/2904256/how-can-i-convert-bigint-unix-timestamp-to-datetime-in-sql-server