请教在oracle9i中有没有象sqlserver里面的dateadd()函数呀？

[ylffsy]

我想通过sql来查找在两个日期之间的记录
select BT,RCLX,RCID,CFLX,DATEPART(hh,KSSJ) kshour ,DATEPART(mi,KSSJ) ksmin ,DATEPART(dw,KSSJ) weekd from T_RCAP where RYID =18 and ( (KSSJ >DATEADD(dd,-6, '2003-3-14 23:59') and KSSJ < DATEADD(dd,-4,'2003-3-14 00:00')) or CFLX in('e0','w1','d9','m3d9')) order by KSSJ
上面的sql是在sqlserver下查找现在要换在oracle9i里面请问如何写sql呀

[bobfang]

可以直接将日期表达式加（减）一数值。如DATEADD(dd,-4,'2003-3-14 00:00')就可以写为to_date('2003-3-14 00:00','yyyy-mm-dd hh24:mi')-4

[beckhambobo]

select BT,RCLX,RCID,CFLX,to_char(KSSJ,'hh24') kshour ,to_char(KSSJ,'mi') ksmin ,to_char(KSSJ,'day') weekd from T_RCAP where RYID =18 and ( (KSSJ >(to_date('2003-3-14 23:59','yyyy-mm-dd hh24:mi')-6) and KSSJ < (to_date('2003-3-14','yyyy-mm-dd')-4) or CFLX in('e0','w1','d9','m3d9')) order by KSSJ