sqlserver查询两个日期之间的数据
select * from cux_oa_contracts_nc_v where CREATETIME >= DATEADD(day,0,'2017-04-21 00:00:00') and CREATETIME <= DATEADD(day,0,'2018-04-21 23:59:59') order by CREATETIME
oracle查询两个日期之间的数据
Select * from cux_oa_contracts_nc_v
where CREATETIME >= to_date('2004-03-02 00:00:00','yyyy-mm-dd hh24:mi:ss')
and CREATETIME <= to_date('2018-04-21 23:59:59','yyyy-mm-dd hh24:mi:ss')
或者
select * from lc0019999.vw_mdmwldw --8187-5=8182
where
zhxgsj between to_date('2019/10/25 00:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date('2019/10/29 23:59:59','yyyy-mm-dd hh24:mi:ss')