This function indicates the current time stamp.
CURRENT_TIMESTAMP value-function::= {CURRENT_TIMESTAMP [(fractional-second-precision)]|CURRENT TIMESTAMP [(fractional-second-precision)]}
Table 1-13 Correspondence between the value of fractional second precision p and the defined length of CHAR when specifying CURRENT_TIMESTAMP as an update or insertion value
Value of fractional second precision p | Defined length of CHAR | |
---|---|---|
Default character set or a character set other than UTF-16 | UTF-16 character set | |
0 | 19 | 38 |
2, 4, or 6 | 20 + p | 40 + p x 2 |