gistfile1.sql

select * from sale where product_id = :product_id and 
sale_date >= TO_DATE('03/30/2013 08:00', 'MM/DD/YYYY HH24:MI')


select * from sale where product_id=:product_id and 
sale_date >= TO_DATE('03/30/2013 08:00', 'MM/DD/YYYY HH24:MI')


select * from sale where product_id = :product_id and 
sysdate - :sale_date < 30


select * from sale where product_id=:product_id and 
sysdate-:sale_date<30


select * from sale where product_id = :product_id and 
sysdate - (:sale_date) < 30


select * from sale where product_id = :product_id and 
sysdate-(:sale_date)<30

select * from sale where product_id = :product_id and 
sysdate - 30 < :sale_date
 
 
select * from sale where product_id=:product_id and 
sysdate-30<:sale_date
 
 
select * from sale where product_id = :product_id and 
sysdate - 30 < (:sale_date)
 
 
select * from sale where product_id = :product_id and 
sysdate-30<(:sale_date)