error_on_overlap_time

Description

error_on_overlap_time specifies whether to return an error when ambiguous time zones occur in the overlap period of daylight saving time.

Privilege requirements

• Query variables

  • Global level

    The sys tenant and all user tenants can query the value of Global system variables by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_GLOBAL_VARIABLE view (Oracle mode) and the information_schema.GLOBAL_VARIABLES view (MySQL mode).

  • Session level

    The sys tenant and all user tenants can query the value of Session system variables by using the SHOW VARIABLES statement or the SYS.TENANT_VIRTUAL_SESSION_VARIABLE view (Oracle mode) and the information_schema.SESSION_VARIABLES view (MySQL mode).

• Modify variables

  • Global level

    • The sys tenant can directly modify the value of Global system variables.

    • MySQL user tenants must have the SUPER or ALTER SYSTEM privilege to modify the value of Global system variables.

    • Oracle user tenants must have the ALTER SYSTEM privilege to modify the value of Global system variables.

  • Session level

    The sys tenant and all user tenants can directly modify the value of Session system variables.

Attributes

Examples

Do not return an error when ambiguous time zones occur in the overlap period of daylight saving time.

• Global level

  obclient> SET GLOBAL error_on_overlap_time =OFF;
  

• Session level

  obclient> SET error_on_overlap_time =OFF;