Note
This variable is available starting with V2.2.77.
Description
TIMESTAMP is a timestamp, in seconds. This variable affects the result of select now(6).
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_SESSION_VARIABLEview (Oracle mode) or theinformation_schema.SESSION_VARIABLESview (MySQL mode) to view the values of Session system variables.Modify variables
systenants and all user tenants can directly modify the values of Session system variables in their own tenants.
Attributes
| Attribute | Description |
|---|---|
| Type | Numeric |
| Default value | 0 |
| Value range | [0, 253402272000) |
| Scope | Session |
| Modifiable | Yes. You can execute the SET statement to modify the value. |