-- 计算时间戳
-- create or alter
alter function f_timestamp (@time datetime) returns bigint
with encryption
as
begin
return convert(bigint, datediff(MI,'1970-01-01 00:00:00.000', @time)) * 60000 + datepart(S, @time) * 1000 + datepart(MS, @time)
end
12-15
03-17
2631
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
01-28
4051
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)