{"id":1164,"date":"2020-11-06T14:11:34","date_gmt":"2020-11-06T14:11:34","guid":{"rendered":"https:\/\/blog.hostinger.io\/support\/2020\/11\/06\/4605619-how-to-change-the-database-timezone-on-phpmyadmin-at-hostinger\/"},"modified":"2025-08-27T07:09:22","modified_gmt":"2025-08-27T07:09:22","slug":"4605619-how-to-change-the-database-timezone-on-phpmyadmin-at-hostinger","status":"publish","type":"post","link":"https:\/\/www.hostinger.com\/support\/4605619-how-to-change-the-database-timezone-on-phpmyadmin-at-hostinger\/","title":{"rendered":"How to Change the Database Timezone on phpMyAdmin at Hostinger"},"content":{"rendered":"<p class=\"no-margin\">You can easily set the time zone of your <b>database session<\/b> by using an SQL command in phpMyAdmin. Just <b><a href=\"\/support\/1583545-how-to-access-phpmyadmin-in-hpanel\" target=\"_blank\" class=\"intercom-content-link\">open your database using phpMyAdmin<\/a><\/b> and go to the <b>SQL<\/b> section:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/11\/63e59cd6-436a-4e61-a6cd-87527662f18c.jpg\"><\/div><p class=\"no-margin\">Once there, insert the following command:<\/p><p class=\"no-margin\">\n<\/p><pre><code>SET time_zone = '+hh:00';<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Replacing <b>+hh<\/b> with the UTC timezone. For example, UTC-03:00 would be:<\/p><p class=\"no-margin\">\n<\/p><pre><code>SET time_zone = '-03:00';<\/code><\/pre><p class=\"no-margin\">\n<\/p><p class=\"no-margin\">Next, click on the <b>Go<\/b> button to apply the changes:<\/p><p class=\"no-margin\">\n<\/p><div class=\"intercom-container intercom-align-center\"><img decoding=\"async\" src=\"\/support\/wp-content\/uploads\/sites\/55\/2020\/11\/4ced9f93-1fe5-443e-a8ab-9757e89f5e62.jpg\"><\/div><p class=\"no-margin\">That&rsquo;s it! You have successfully changed the time zone for the <b>current MySQL session <\/b>on your database.<\/p><p class=\"no-margin\">\n<\/p><p class=\"no-margin\"><b>NOTES<\/b>: <\/p><ul>\n<li>\n<p class=\"no-margin\">After the <b>current session ends<\/b>, the time zone will be changed to the <b><a href=\"\/support\/1583329-what-is-the-timezone-of-your-servers\" target=\"_blank\" class=\"intercom-content-link\">default one<\/a> <\/b>(UTC+00:00). Alternatively, you can use the <b><a href=\"https:\/\/support.hostinger.com\/php\/how-can-i-modify-the-php-timezone-setting-for-my-website\" target=\"_blank\" class=\"intercom-content-link\" rel=\"noopener\">PHP date_default_timezone<\/a> <\/b>function to set your website&rsquo;s timezone<\/p>\n<\/li>\n<li>\n<p class=\"no-margin\">If you need to permanently change your <b>global server timezone<\/b>, you can consider a <b><a href=\"https:\/\/www.hostinger.com\/vps-hosting\" target=\"_blank\" class=\"intercom-content-link\">VPS plan<\/a><\/b><\/p>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Changing the time zone of a database via phpMyAdmin on Hostinger<\/p>\n","protected":false},"author":581,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"include_on_kodee":true,"footnotes":""},"categories":[240],"tags":[],"class_list":["post-1164","post","type-post","status-publish","format-standard","hentry","category-advanced"],"hreflangs":[{"locale":"en-US","link":"https:\/\/www.hostinger.com\/support\/4605619-how-to-change-the-database-timezone-on-phpmyadmin-at-hostinger\/","default":1},{"locale":"es-ES","link":"https:\/\/www.hostinger.com\/es\/support\/4605619-como-cambiar-la-zona-horaria-de-la-base-de-datos-en-phpmyadmin-en-hostinger\/","default":0},{"locale":"fr-FR","link":"https:\/\/www.hostinger.com\/fr\/support\/4605619-comment-changer-le-fuseau-horaire-de-la-base-de-donnees-sur-phpmyadmin\/","default":0},{"locale":"id-ID","link":"https:\/\/www.hostinger.com\/id\/support\/4605619-bagaimana-cara-mengubah-zona-waktu-database-di-phpmyadmin-di-hostinger\/","default":0},{"locale":"pt-PT","link":"https:\/\/www.hostinger.com\/br\/support\/4605619-como-alterar-o-fuso-horario-do-banco-de-dados-no-phpmyadmin-hostinger\/","default":0},{"locale":"uk-UA","link":"https:\/\/www.hostinger.com\/ua\/support\/4605619--------phpmy\/","default":0}],"include_on_kodee":true,"_links":{"self":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1164","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/users\/581"}],"replies":[{"embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/comments?post=1164"}],"version-history":[{"count":1,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1164\/revisions"}],"predecessor-version":[{"id":4590,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/posts\/1164\/revisions\/4590"}],"wp:attachment":[{"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/media?parent=1164"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/categories?post=1164"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.hostinger.com\/support\/wp-json\/wp\/v2\/tags?post=1164"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}