oracle8.1.6 txn_attempted_time + 1 > sysdate txn_attempted_time + 7 > sysdate add_months(txn_attempted_time,1) > sysdate 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]