SET CURRENT TEMPORAL SYSTEM_TIME statement

Invocation for SET CURRENT TEMPORAL SYSTEM_TIME

This statement can be embedded in an application program or issued interactively. It is an executable statement that can be dynamically prepared.

Authorization for SET CURRENT TEMPORAL SYSTEM_TIME

None required.

Description for SET CURRENT TEMPORAL SYSTEM_TIME

NULL

Specifies the null value.

expression

Specifies an expression that returns the null value or the value of one of the following built-in data types:

• Timestamp
• Character string
• Graphic string

If the expression is a character or graphic string, it must meet the following requirements:

• It must not be a CLOB or DBCLOB.
• The value of the expression must be a valid character-string or graphic-string representation of a timestamp.
• The result of the expression must be castable to TIMESTAMP(12).

expression can contain any of the following supported operands:

• Constant
• Special register
• Variable (host variable, SQL parameter, SQL variable, or global variable)
• Scalar function whose arguments are supported operands
• CAST specification where the cast operand is a supported operand
• Expression that uses arithmetic operators and operands

For more information, see:

• String representations of datetime values
• Casting between data types

Notes for SET CURRENT TEMPORAL SYSTEM_TIME

Transactions

The SET CURRENT TEMPORAL SYSTEM_TIME statement is not a committable operation. The ROLLBACK statement has no effect on CURRENT TEMPORAL SYSTEM_TIME.

Effects on other special registers

The setting of the CURRENT TEMPORAL SYSTEM_TIME special register does not affect other special registers, such as the CURRENT DATE and CURRENT TIMESTAMP special registers.