postgresql7.1 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 select ec_interaction_id_sequence.nextval select ec_interaction_id_sequence.nextval select ec_user_ident_id_sequence.nextval