Still use 'DATE', Date also save the time.
create table class
(schedule_num integer primary key not null,
semester varchar(10),
course_name varchar(14),
credit int,
department varchar(15),
meeting_time DATE,
meeting_place varchar(20),
enrollment_limit int);
Example :
select to_char(meeting_time,'HH24:MI:SS') from class
Jx_Man
Senior Poster
3,529 posts since Nov 2007
Reputation Points: 1,488
Solved Threads: 521
Skill Endorsements: 64