oracle8.1.6 insert into dotlrn_terms (term_id, term_name, term_year, start_date, end_date) values (:term_id, :term_name, :term_year, to_date(:start_date, :date_format), to_date(:end_date, :date_format)) update dotlrn_terms set term_name = :term_name, term_year = :term_year, start_date = to_date(:start_date, :date_format), end_date = to_date(:end_date, :date_format) where term_id = :term_id select to_char(dotlrn_terms.start_date, :date_format) as start_date, to_char(dotlrn_terms.start_date, 'YYYY') as year, to_char(dotlrn_terms.start_date, 'MM') as month, to_char(dotlrn_terms.start_date, 'DD') as day from dotlrn_terms where dotlrn_terms.term_id = :term_id select to_char(dotlrn_terms.end_date, :date_format) as end_date, to_char(dotlrn_terms.end_date, 'YYYY') as year, to_char(dotlrn_terms.end_date, 'MM') as month, to_char(dotlrn_terms.end_date, 'DD') as day from dotlrn_terms where dotlrn_terms.term_id = :term_id select dotlrn_terms.term_name || ' ' || dotlrn_terms.term_year as term, dotlrn_terms.term_id from dotlrn_terms where dotlrn_terms.end_date > sysdate order by dotlrn_terms.start_date