By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE FUNCTION [dbo].Epoch_TIMESTAMP ()
RETURNS BIGINT
AS BEGIN
RETURN DATEDIFF(s, '1970-01-01', GETUTCDATE())
END
SELECT [dbo].Epoch_TIMESTAMP ()
| (No column name) |
|---|
| 1537635988 |