mysql的TIMESTAMPDIFF

SELECT (TIMESTAMPDIFF(MINUTE, STR_to_date('2018-8-30 12:15:52', '%Y-%m-%d %H:%i:%s') , STR_to_date('2018-8-31 15:05:31', '%Y-%m-%d %H:%i:%s')))/60/24

 

得到

1.11736111

 

posted on 2018-08-31 13:54  小甜瓜安东泥  阅读(342)  评论(0编辑  收藏  举报