指定时间范围查询

SEC.SEC_MENU_CLICK_RECORD_LOG_YYYYMM和 sec.Sec_Resource_Records_YYYYMM
这两个表中上述操作信息的数据 ：统计下上述条件的菜单访问量
条件：工号 90211632 菜单： 77770092 目标客户活动查询
测试时间范围：2022-1-12 16:50至2022-1-12 16:58

select count(1)
from SEC.SEC_MENU_CLICK_RECORD_LOG_202201 a
where MENU_ENTITY_ID = ‘77770092’ and OP_ID = ‘90211632’
and INTERVIEW_TIME between to_date(‘20220112165000’, ‘yyyymmddhh24miss’) and to_date(‘20220112165800’, ‘yyyymmddhh24miss’)

select count(1) from sec.Sec_Resource_Records_202201 a where SUB_ACCOUNT_NAME=’90211632’ and MODULE_ID=’77770092’
and create_date between to_date(‘20220112165000’, ‘yyyymmddhh24miss’) and to_date(‘20220112165800’, ‘yyyymmddhh24miss’);