Oralce 按时间区间作为筛选条件查询数据

select reply.assign_investigator1,reply.assign_investigator1_tel,reply.assign_investigator2,reply.assign_investigator2_tel,
assign.case_id
from CASE_T_ASSIGN_REPLY reply
left join case_t_assign assign on assign.assign_id = reply.assign_id
where
create_time between to_date('2018-11-21 00:00:21','yyyy-mm-dd hh24:mi:ss') and to_date('2018-11-21 17:40:21','yyyy-mm-dd hh24:mi:ss')
and assign_investigator1 is not null

标签: none

添加新评论