The unix time stamp is merely the   number of seconds between a particular date and the Unix Epoch,

SELECT DATEDIFF(SECOND,{d '1970-01-01'},GETDATE())  //...