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 |
---|---|---|---|---|
| int | No | Identifier; primary key. | |
| tinyint | No | Integer between 0 and 23, indicating the hour within the day. | |
| tinyint | No | Integer between 0 and 59, the number of the minute within the hour. | |
| smallint | No | Integer between 0 and 1439, the number of the minute within the day. | |
| tinyint | No | Either 0 (indicating AM) or 1 (indicating PM). | |
| tinyint | No | Integer between 0 and 11, indicating the hour within a twelve-hour half day. |