DECLARE MyTimeStamp TIMESTAMP; SET MyTimeStamp = TIMESTAMP '1999-12-31 23:59:59';
The
year field must always be four digits in length. The month, day, hour, and
minute fields must always be two digits. (Do not omit leading zeroes.) The
optional fractional seconds field can be 0 - 6 digits long.