sql server低版本封装获取时间戳函数

2025-07-25 本文已影响0人吉凶以情迁


CREATE FUNCTION dbo.GetUnixTimestampMs(@inputDate DATETIME)
RETURNS BIGINT
AS
BEGIN
    DECLARE @timestamp BIGINT
    
    -- SQL Server 2014兼容的毫秒级时间戳计算
    SET @timestamp = CAST(DATEDIFF(SECOND, '1970-01-01', @inputDate) AS BIGINT) * 1000 + DATEPART(MILLISECOND, @inputDate)
    
    RETURN @timestamp
END
GO

我目前是1753524079120