Get Current Unix Epoch Time-stamp in seconds in SQL Server

Question

I have the following C# method to get current unix epoch time stamp,

    public static long GetCurrentUnixTimestampSeconds()
    {
        var unixEpoch = new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc);
        return (long)(DateTime.UtcNow - unixEpoch).TotalSeconds;
    }

I need the same in SQL Server. Is it possible?

Answer 1

This is just the number of seconds between epoch and current UTC time:

SELECT DATEDIFF(SECOND, '19700101', sysutcdatetime());