This table has information about the time of day. There is one row for each minute of one day, representing clock time.

Column Name

Type

Length

Null Allowed

Description

ID

int

No

Identifier; primary key.

HOUR_OF_DAY

tinyint

No

Integer between 0 and 23, indicating the hour within the day.

MIN_OF_HOUR

tinyint

No

Integer between 0 and 59, the number of the minute within the hour.

MIN_OF_DAY

smallint

No

Integer between 0 and 1439, the number of the minute within the day.

HALFDAY_OF_DAY

tinyint

No

Either 0 (indicating AM) or 1 (indicating PM).

HOUR_OF_HALFDAY

tinyint

No

Integer between 0 and 11, indicating the hour within a twelve-hour half day.


Copyright © 1997, 2013 Oracle and/or its affiliates. All rights reserved. Legal Notices