To view time zone in ApsaraDB for RDS, run the following SQL statement:
show global variables like ‘%time_zone%’;
You can modify the time zone on RDS console. The procedure is as follows:
Log on to RDS console.
Select the region where the target instance is located.
Click the ID of the target instance to enter the Basic Information page.
In the left-side navigation bar, select Parameters to enter the Parameters page.
Select the Modifiable Parameters tab page.
Modify the value of default_time_zone, as shown in the following figure.
Note: The parameter default_time_zone supports some of the time zones that are offset by 30 minutes, such as +5:30.