drop table test;

create table test (a integer, dob DATE, time DATE);

insert into test values(5, to_date('01/01/05', 'MM/DD/YY'),
                        to_date('11:20:30am', 'HH:MI:SSAM'));
