Mysql的BETWEEN and使用
SELECT
o.create_by as create_by,
COUNT(o.create_by) as ojbts
FROM
oa_overtime o
WHERE
starttime BETWEEN date_add( '2019-01-31 00:00:00', INTERVAL - DAY ( '2019-01-31 00:00:00' ) + 1 DAY )
AND '2019-01-31 00:00:00'
GROUP BY
o.create_by
遇到的sql,BETWEEN这段没看懂,拆开单独才出来执行是这样的
SELECT DAY ( '2018-11-11 15:05:14' ) as a from dual
传入时间是当月第几天
运行结果看下图
SELECT
date_add( '2018-11-11 15:05:14', INTERVAL - DAY ( '2018-11-11 15:05:14' ) + 1 DAY ) AS a
FROM
DUAL
计算传入时间的月份第一天
运行结果看下图
where (数据库字段) BETWEEN (参数1)AND(参数2)
数据库字段在参数1和参数2之间