How do I create a "time" field???

[lminmei]

This is a beginner question....
I am creating a table with a field called time and i just want that field to store hh:mm AM/PM ...
How do i do this in the CREATE TABLE statement???

Please help,
Thanks

 

[jee]

Oracle doesn't support just a time field. It has a DATE field that contains both time and date. You declare it like this

create table xxx (
.
.
.
   archive_date_time  DATE
.
.
.
)

If you just want to see the time component, when you query use the TO_CHAR function and only specify the time... like this:

SELECT TO_CHAR (archive_date_time, 'HH:MI:SS AM') archive_time
FROM xxx
WHERE
.
.
.

Another option is to use a CHAR or VARCHAR2 field of the proper length and just store times.