WHERE
1=1
AND (
(
i.invoice_draw_time >= TO_DATE ('2012-11-08 00:00:00' , 'yyyy-mm-dd hh24:mi:ss')
AND i.invoice_draw_time <= TO_DATE ('2012-11-08 23:59:59' , 'yyyy-mm-dd hh24:mi:ss')
)
OR (
invoice_draw_date >= TO_DATE ('2012-11-08 00:00:00' , 'yyyy-mm-dd hh24:mi:ss')
AND invoice_draw_date <= TO_DATE ('2012-11-08 23:59:59' , 'yyyy-mm-dd hh24:mi:ss')
)
)
1=1
AND (
(
i.invoice_draw_time >= TO_DATE ('2012-11-08 00:00:00' , 'yyyy-mm-dd hh24:mi:ss')
AND i.invoice_draw_time <= TO_DATE ('2012-11-08 23:59:59' , 'yyyy-mm-dd hh24:mi:ss')
)
OR (
invoice_draw_date >= TO_DATE ('2012-11-08 00:00:00' , 'yyyy-mm-dd hh24:mi:ss')
AND invoice_draw_date <= TO_DATE ('2012-11-08 23:59:59' , 'yyyy-mm-dd hh24:mi:ss')
)
)
1=1
AND (
(
i.invoice_draw_time >= TO_DATE ('2012-11-08 00:00:00' , 'yyyy-mm-dd hh24:mi:ss')
AND i.invoice_draw_time <= TO_DATE ('2012-11-08 23:59:59' , 'yyyy-mm-dd hh24:mi:ss')
)
union all
where
invoice_draw_date >= TO_DATE ('2012-11-08 00:00:00' , 'yyyy-mm-dd hh24:mi:ss')
AND invoice_draw_date <= TO_DATE ('2012-11-08 23:59:59' , 'yyyy-mm-dd hh24:mi:ss')
)
)