[筆記][TSQL]timestamp轉換

SELECT DATEDIFF(SECOND,'1970-01-01', GETUTCDATE()) AS 'UNIX TIMESTAMP';

SELECT DATEADD(s,unix_timestamp,'1970-01-01') as 時間

EX:
SELECT DATEADD(s,1694617261,'1970-01-01') as 時間