發(fā)布時(shí)間是剛剛還是幾分鐘、幾小時(shí)、幾天前
語句:
if(timestampdiff(hour,refreshtime,now())<1,
if(timestampdiff(minute,refreshtime,now())=0,'剛剛',concat(timestampdiff(minute,refreshtime,now()),'分鐘前')),
if(timestampdiff(hour,refreshtime,now())<24 ,concat(timestampdiff(hour,refreshtime,now()),'小時(shí)前'),
if(timestampdiff(day,refreshtime,now())<2,'昨天',concat(timestampdiff(day,refreshtime,now()),'天前')))) as refreshinfo