-- 当月填写工时人员数
SELECT COUNT(F_USERID) AS "当月总人数" FROM T_TIMEENTRY WHERE F_ENTRYDATE BETWEEN to_date('2018-09-01','yyyy-MM-dd') AND to_date('2018-09-30','yyyy-MM-dd')
oracle按时间查询
最新推荐文章于 2024-06-13 14:07:11 发布
-- 当月填写工时人员数
SELECT COUNT(F_USERID) AS "当月总人数" FROM T_TIMEENTRY WHERE F_ENTRYDATE BETWEEN to_date('2018-09-01','yyyy-MM-dd') AND to_date('2018-09-30','yyyy-MM-dd')