timestamp

2025-11-14 07:33:33  Updated

Note

This variable is available starting with in V2.2.77.

Description

TIMESTAMP is a timestamp value in seconds. This variable affects the result of SELECT NOW(6).

Privilege requirements

  • Query variables

    The sys tenant and all user tenants can query the value of a session system variable by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (in Oracle-compatible mode) or the information_schema.SESSION_VARIABLES view (in MySQL-compatible mode).

  • Modify variables

    The sys tenant and all user tenants can directly modify the value of a session system variable in their own tenant.

Attributes

Attribute Description
Parameter type Numeric
Default value 0
Value range [0, 253402272000)
Effective scope Session
Modifiable Yes. The value can be modified by using the SET statement.

Contact Us