Quick Tips to know about mysql server Timezone

Quick Tips to know about mysql server Timezone

Last day worked in a project and I required to know what is my current PhpMyAdmin (mysql) server timezone. It’s really very important while you are working on a application that worked based on user timezone. So, we need to know SQL server timezone to adjust our server date and time with user local devices date and time. It’s very easy to know MySql server time zone. Here goes query string –

SELECT @ @global.time_zone , @ @session.time_zone

 

This query show you server global time zone also your session time zone. Isn’t it cool ?

After run this query you will see output like following image.

quick tips to know about mysql server timezone

Hope you enjoyed that quick tips. Was this information useful? What other tips would you like to read about in the future? Share your comments, feedback and experiences with us by commenting below!

Tags:  

Share It

Related Posts