sqlserver和oracle查询两个日期之间的数据在代码里的

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')