Value(Bigint)--- Datetime 1333270800------ '2012-04-01 09:00:00.000 1333274400------ '2012-04-01 10:00:00.000' 381403800------- '1982-02-01 09:30:00.000' 1270116000------ '2012-02-26 10:00:00.000' 127013003------- '2012-04-01 10:00:00.000'
SELECT DATEADD(S, @your-big-int, '19700101')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)