How to Configure DataBase TimeZone

 

Listing out current database timezone 

SQL: show variables like '%time_zone%';

database default timeZone is EDT timeZone.

Configure current Database console time_zone

SQL: set time_zone = 'America/Chicago';

Reset the current database session to another timeZone.

Showing current DateTime

SQL: select now();