函数内指定是minute,则最终结果value值的单位是分钟,如果函数内指定为hours,则最终结果value值单位为小时。


   
    
  1. //UPLOAD_TIME 减去 CREATE_DTTM 求得时间差,以分钟数计时
  2. select avg( TIMESTAMPDIFF( MINUTE,CREATE_DTTM,UPLOAD_TIME)) value, LEFT(CREATE_DTTM, 10) time from 表名
  3. WHERE
  4. CREATE_DTTM >= '2018-01-21'
  5. AND CREATE_DTTM <= DATE_ADD( '2019-02-19', INTERVAL 1 DAY) and UPLOAD_TIME is not null
  6. group by LEFT(CREATE_DTTM, 10)

参考:IT虾米网

IT虾米网


   
    
  1. mysql> SELECT TIMESTAMPDIFF(MONTH,'2003-02-01','2003-05-01');
  2. -> 3
  3. mysql> SELECT TIMESTAMPDIFF(YEAR,'2002-05-01','2001-01-01');
  4. -> - 1
  5. mysql> SELECT TIMESTAMPDIFF(MINUTE,'2003-02-01','2003-05-01 12:05:55');
  6. -> 128885

原文地址:https://blog.csdn.net/weixin_38750084/article/details/88118039


评论关闭
IT序号网

微信公众号号:IT虾米 (左侧二维码扫一扫)欢迎添加!