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. |