TIME
The TIME
data type is a fixed length data type that contains a time-of-day. The
TIME data type uses 6 bytes of storage and has a precision of fifteen
and a scale of three. All time values entered are assumed to be in twenty-four
hour format by default unless the optional values 'AM' and 'PM' are specified.
The TIME data type has multiple input and output formats. If the values
in the database do not appear correctly, or you are not able to enter
times you think are valid, you should check the time input and output
formats to make sure they are correct.
| e.g. |
'22:04:05.666' |
| |
'10:04:05.666
PM' |
<
SERIAL | Contents
| TIMESTAMP >
|
