08 2023 档案

Mysql按照固定时间间隔统计数据
摘要：SELECT STCD, DATE_FORMAT(TM, '%Y-%m-%d %08:%00:%00') AS TM, SUM(DRP) AS DRP, FLOOR(UNIX_TIMESTAMP(TM) / (24 * 60 * 60)) AS timekeyFROM st_pptn_rWHERE 阅读全文
posted @ 2023-08-06 10:43 谁说我不是会员 阅读(81) 评论(0) 推荐(0)