postgresql7.1 txn_attempted_time + '1 days'::interval > now() txn_attempted_time + '7 days'::interval > now() txn_attempted_time + '1 months'::interval > now() select transaction_id, to_char(txn_attempted_time, 'MM-DD-YYYY HH24:MI:SS') as txn_time, txn_attempted_type, response, response_code, response_reason_code, response_reason_text, auth_code, avs_code, amount from authorize_gateway_result_log where '1'='1' [ad_dimensional_sql $dimensional] [ad_order_by_from_sort_spec $orderby $table_def]