sql中的timestampdiff函数

计算两个时间相减的差值

1、前值小于后值时

select timstampdiff ( month,'20250301' , '2025-04-01 00:00:00.000')

select timstampdiff ( month,'20250301' , '2025-04-05 00:00:00.000')

结果均是1

 

2、前值大于后值

select timstampdiff ( month,'20250501' , '2025-04-01 00:00:00.000')

结果是-1

select timstampdiff ( month,'20250501' , '2025-04-05 00:00:00.000')

结果是0

 

 

 

https://blog.csdn.net/weixin_35770067/article/details/143165467