create table testtime(
       id number,
       name varchar2(100),
       age number,
       time varchar2(100)
)

insert into testtime(id,name,age,time) values(1,'name1',20,'2012-05-17 09');
insert into testtime(id,name,age,time) values(2,'name2',21,'2012-05-18 19');
insert into testtime(id,name,age,time) values(4,'name4',23,'2012-05-20 13');
insert into testtime(id,name,age,time) values(5,'name5',24,'2012-05-21 23');