postgresql7.1 select sale_price_id, sale_name, sale_price, offer_code, to_char(sale_begins,'YYYY-MM-DD HH24:MI:SS') as sale_begins, to_char(sale_ends,'YYYY-MM-DD HH24:MI:SS') as sale_ends, case when current_timestamp > sale_begins then 1 else 0 end as sale_begun_p, case when current_timestamp > sale_ends then 1 else 0 end as sale_expired_p from ec_sale_prices_current where product_id=:product_id order by last_modified desc select sale_price_id, sale_name, sale_price, offer_code, to_char(sale_begins,'YYYY-MM-DD HH24:MI:SS') as sale_begins, to_char(sale_ends,'YYYY-MM-DD HH24:MI:SS') as sale_ends, case when current_timestamp > sale_begins then 1 else 0 end as sale_begun_p, case when current_timestamp > sale_ends then 1 else 0 end as sale_expired_p from ec_sale_prices where product_id=:product_id and (sale_begins > current_timestamp or sale_ends < current_timestamp) order by last_modified desc