oracle8.1.6 select to_char(interaction_date, 'YYYY-MM-DD HH24:MI:SS') as open_date_str from ec_customer_serv_interactions where interaction_id=:interaction_id to_date(:open_date_str,'YYYY-MM-DD HH24:MI:SS') null null insert into ec_customer_service_issues (issue_id, user_identification_id, order_id, open_date, close_date, closed_by) values (:issue_id, :uiid_to_insert, :order_id, $date_string, $close_date, $customer_service_rep_bit)