mysqlは2つの時間差を計算します

キーワード:TIMESTAMPDIFF

TIMESTAMPDIFF（type,time1,time2）
type:     （day  ，week   ，YEAR  ）
time1:    
time2:    

    :
1.       2018-10-10         
select  TIMESTAMPDIFF(DAY,'2018-10-10',NOW()) 
2.       
select * from  table_name ORDER BY  TIMESTAMPDIFF(DAY,create_time,NOW()) asc
   TIMESTAMPDIFF  Mysql          ，MONTH          ，（   month，    minute ）