TIMESTAMP
The TIMESTAMP
data type is a fixed length data type that contains a calendar data and
a time-of-day. The TIMESTAMP data type uses 12 bytes of storage and has
a precision of 27 and a scale of 3. Valid years are from 0001 to 9999.
. 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 TIMESTAMP
data type uses the input and output formats for the TIME and DATE data
types to display values and determine if input values are valid. 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. |
'1997/01/01
10:02:03.444 PM' |
| |
'01.01.1997
22:02:03.444' |
<
TIME | Contents
| VARCHAR >
|
