Description
TIMESTAMP is the timestamp in seconds. The variable affects the result of SELECT NOW(6).
Privilege requirements
Query variables
systenant and all user tenants can view the values of session system variables by using theSHOW VARIABLESstatement or by querying theSYS.TENANT_VIRTUAL_SESSION_VARIABLE(Oracle mode) orinformation_schema.SESSION_VARIABLES(MySQL mode) view.Modify variables
The
systenant and all user tenants can directly modify the values of the session system variables for their tenants.
Attributes
| Attribute | Description |
|---|---|
| Data type | Numeric |
| Default value | 0 |
| Value range | [0, 253402272000) |
| Scope | Session |
| Yes | Yes. You can run the SET statement to modify the parameter. |