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
systenant and all user tenants can query the value of a session system variable by using theSHOW VARIABLESstatement or theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (in Oracle-compatible mode) or theinformation_schema.SESSION_VARIABLESview (in MySQL-compatible mode).Modify variables
The
systenant 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. |