oracle8.1.6
insert
into dotlrn_terms
(term_id, term_name, term_year, start_date, end_date)
values
(acs_object_id_seq.nextval, :term_name, :term_year, to_date(:start_date, :date_format), to_date(:end_date, :date_format))
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