You probably already thought of this, but just in case....


use 12/31/69 19:00 as your seed time...


declare @epochlocal as integer

set @epochlocal = 1114059600

select @epochlocal Epoch, dateadd(s,@epochlocal,'12/31/1969 19:00:00')
Calendar

MS Sql Server LazyDBA home page