(
CASE
WHEN TIMESTAMPDIFF( MINUTE, '时间', NOW( ) ) > 60 THEN
IF
(
TIMESTAMPDIFF( HOUR, '时间',, NOW( ) ) > 24,
IF
(
TIMESTAMPDIFF( DAY, '时间',, NOW( ) ) > 365,
CONCAT( TIMESTAMPDIFF( YEAR, '时间',, NOW( ) ), '年前' ),
CONCAT( TIMESTAMPDIFF( DAY, '时间',, NOW( ) ), '天前' )
),
CONCAT( TIMESTAMPDIFF( HOUR, v.createtime, NOW( ) ), '小时前' )
) ELSE CONCAT( TIMESTAMPDIFF( MINUTE, '时间',, NOW( ) ), '分钟前' )
END
) AS `time`
mysql提取数据在几天前,几月前,几年前
最新推荐文章于 2023-11-23 09:50:19 发布