Timestamp data type
The following table describes the timestamp data types. See
SQL: Data types for a description of the column headings.
|
Data type
|
Size
|
Precision
|
Scale
|
Length
|
Display size
|
|
TIMESTAMP
|
N/A
|
|
9
|
|
|
1 The number of characters in the yyyy-mm-dd hh:mm:ss.fffffffff format
2 The size of the TIMESTAMP_STRUCT structure
3 Size is 29 with a decimal fraction part
Go up to