View MySQL Time Zone Settings

1 year ago
Sophia Anderson
1 minute

To view data in the current time zone in MySQL, you can use the following statement:

SELECT @@global.time_zone AS 'Global Time Zone', @@session.time_zone AS 'Session Time Zone';

This will return two results, one being the global time zone and the other being the session time zone. The global time zone is the default time zone of the MySQL server, while the session time zone is the time zone setting for the current session.

You can use the following statement if you want to check the current date and time:

SELECT NOW();

This will return the current date and time along with time zone information.

bannerAds