计算距离生日多少天(最简便SQL语句)
select datediff(concat(substring(current_timestamp(6),1,4),substring(hbirth,5)),current_timestamp(6)) day from human where hid=1001select datediff(concat(substring(current_timestamp(6),1,4)+1,subs...
原创
2018-09-03 23:33:17 ·
5245 阅读 ·
0 评论