How do I set the time zone of MySQL?

Question

On one server, when I run:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 16:54:29 |
+---------------------+
1 row in set (0.00 sec)

On another server:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2009-05-30 20:01:43 |
+---------------------+
1 row in set (0.00 sec)

There's not just a timezone difference here - but a not-so-insignificant time-drift as well: _"Talk to your DBA about `ntp` - and see what's right for you!"_ — colm.anseo, Jun 08 '19 at 13:42
@colm.anseo Calm down it's probably the difference between running the queries — HosseyNJF, May 28 '20 at 17:51
@HosseyNJF by 7 minutes? Coffee break in between comparisons? — colm.anseo, May 28 '20 at 19:00
`system_time_zone` - "When the server begins executing, it inherits a time zone setting from the machine defaults". To change the "system_time_zone": Use `sudo dpkg-reconfigure tzdata` and restart mysql with `sudo service mysql restart`. — Avatar, Nov 15 '22 at 06:21

score 656 · Answer 1 · edited May 23 '17 at 11:54

656

I thought this might be useful:

There are three places where the timezone might be set in MySQL:

In the file "my.cnf" in the [mysqld] section

default-time-zone='+00:00'

@@global.time_zone variable

To see what value they are set to:

SELECT @@global.time_zone;

To set a value for it use either one:

SET GLOBAL time_zone = '+8:00';
SET GLOBAL time_zone = 'Europe/Helsinki';
SET @@global.time_zone = '+00:00';

(Using named timezones like 'Europe/Helsinki' means that you have to have a timezone table properly populated.)

Keep in mind that +02:00 is an offset. Europe/Berlin is a timezone (that has two offsets) and CEST is a clock time that corresponds to a specific offset.

@@session.time_zone variable

SELECT @@session.time_zone;

To set it use either one:

SET time_zone = 'Europe/Helsinki';
SET time_zone = "+00:00";
SET @@session.time_zone = "+00:00";

Both might return SYSTEM which means that they use the timezone set in my.cnf.

For timezone names to work, you must setup your timezone information tables need to be populated: http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html. I also mention how to populate those tables in this answer.

To get the current timezone offset as `TIME`

SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);

It will return 02:00:00 if your timezone is +2:00.

To get the current UNIX timestamp:

SELECT UNIX_TIMESTAMP();
SELECT UNIX_TIMESTAMP(NOW());

To get the timestamp column as a UNIX timestamp

SELECT UNIX_TIMESTAMP(`timestamp`) FROM `table_name`

To get a UTC datetime column as a UNIX timestamp

SELECT UNIX_TIMESTAMP(CONVERT_TZ(`utc_datetime`, '+00:00', @@session.time_zone)) FROM `table_name`

Note: Changing the timezone will not change the stored datetime or timestamp, but it will show a different datetime for existing timestamp columns as they are internally stored as UTC timestamps and externally displayed in the current MySQL timezone.

I made a cheatsheet here: Should MySQL have its timezone set to UTC?

edited May 23 '17 at 11:54

Community

1
1

answered Sep 28 '13 at 16:48

Timo Huovinen

53,325
33
152
143

6

`+00:00` isn't a timezone, it's a time offset. What happens with regards to DST? Does it stay at +0 year-round? – mpen Mar 12 '14 at 00:57
2

@Mark I am not sure, [the docs](https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html) say that when setting `time_zone="+00:00"` you are setting the **timezone** using an offset from UTC, considering that the set value never changes and that UTC does not follow DST I can assume that it stays the same all year round. – Timo Huovinen Mar 14 '14 at 18:49
1

@TimoHuovinen Sorry, I meant that `+00:00` *looks* like an offset so it's kind of strange that MySQL chose that to represent UTC instead of just using the string "UTC" itself. Thanks for the info. – mpen Mar 14 '14 at 19:30
1

I set +00:00, but I get this error: error: Found option without preceding group in config file: /etc/my.cnf – János May 09 '14 at 17:19
1

@János check the encoding of the file, the BOM and the quotes around `+00:00` http://stackoverflow.com/questions/8020297/mysql-my-cnf-file-found-option-without-preceding-group – Timo Huovinen May 09 '14 at 17:28
1

it is not encoding or something like that, I typed it manually – János May 09 '14 at 17:29
1

I have mac and I am using vi ;-) – János May 09 '14 at 17:32
6

in Win7, the path to the mysql settings file is `C:\ProgramData\MySQL\MySQL Server x.x\my.ini` – dev4life Dec 13 '14 at 21:32
1

For me, the underscores in the variable name in the answer, were actually hyphens, as per http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html – Ashley Mar 31 '15 at 02:42
1

@Ashley could you point out the section where it's hyphens? because normally in SQL statements you use underscores – Timo Huovinen Apr 05 '15 at 19:54
1

Add in mysql config (my.ini) in [mysqld] section [mysqld] default-time-zone = UTC – ursuleacv May 28 '15 at 13:20
1

FYI, I had to restart the mysql service (sudo service mysql restart) in order for it to detect system tz changes. On Ubuntu 14.04. – vcardillo Jan 27 '16 at 01:24
1

what about different solar time? every country in europe change the clock different itm of the year – Francesco Feb 09 '16 at 23:59
1

@Francesco I know, it's called DST, the offset in hours does not take that into account, DATETIME fields are stored just like plain strings would, TIMESTAMP gets converted from the current timezone and stored in UTC and converted back to the current timezone when retrieving it, which should work for named timezones like `America/New_York`. I suggest set your db timezone to UTC and store everything as UTC and convert it back when fetching. – Timo Huovinen Feb 10 '16 at 06:47
To get current timezone you may also use: `select timediff(now(),convert_tz(now(),@@session.time_zone,'+00:00'))` – Vahid Amiri Sep 20 '16 at 18:26
1

note that setting `default-time-zone='+00:00'` in the config file will make the value used every time the server restarts. but using `SET GLOBAL time_zone = '+8:00';` query -with privilege account- will not make the server use the value when it is restarted. So I prefer the config file as the edit will be permanent . I'm using mariaDB on windows 7 comes in xampp – Accountant م Jan 12 '17 at 11:01
Im confused as to why mysql does not use the system time by default instead of UTC. Sure for some applications UTC would be the desired time (I can't think of one but im sure there are some). Mostly though I would assume that the system time would be more desirable, especially since the time can be kept in sync with the chosen timezone so handles DST without any changes. ofcourse this will affect applications that are critically reliant on time, such as banking transactions but for the most part surely not such a big deal? – CodingInTheUK Jun 20 '18 at 14:58
@Chris IMHO UTC is the desired time for all applications without exceptions. You will not believe how much of a mess timezones are, and they keep changing even now! It's much easier to avoid all ambiguity and use UTC and then convert from UTC to whatever timezone you feel like, so the app becomes easier to make international. – Timo Huovinen Jul 11 '18 at 10:23
@Chris here is a very good article on when not to use UTC https://codeblog.jonskeet.uk/2019/03/27/storing-utc-is-not-a-silver-bullet/ basically when the time stored represents a future human event. – Timo Huovinen Nov 22 '21 at 11:23

score 112 · Answer 2 · edited Nov 06 '17 at 08:08

112

For anyone still having this issue:

value="jdbc:mysql://localhost:3306/dbname?serverTimezone=UTC"

Worked for me. Just append ?serverTimezone=UTC at the end.

edited Nov 06 '17 at 08:08

rkosegi

14,165
5
50
83

answered Apr 22 '16 at 12:30

Noel Murphy

1,264
1
8
12

1

If my time zone is UTC+7, how could i specify that in the connection string ? I tried appending "?serverTimezone=UTC+7" and it doesn't work. – Chiến Nghê Nov 18 '17 at 17:07
4

The question was not about JDBC, but MySQL itself. – Luiz Dec 11 '17 at 22:52
3

@ChiếnNghê: You should use `Asia/Ho_Chi_Minh` instead of `UTC` BTW, the question is about changing MySQL timezone. So please look at @Timo answer. If you have trouble with MySQL docker, add TZ environment and it should work. – Liem Le Jan 30 '18 at 10:06
5

This **only informs** JDBC what's the server timezone, it **does not** change it. To set session timezone, check answers which use `SET time_zone=...` – Nikola Mihajlović Apr 30 '18 at 23:08
1

The simplest solution – Ahmet Firat Keler Apr 09 '22 at 09:04

score 75 · Answer 3 · edited Jun 05 '18 at 04:31

75

When you can configure the time zone server for MySQL or PHP:

Remember:

Change timezone system. Example for Ubuntu:
```
$ sudo dpkg-reconfigure tzdata
```
Restart the server or you can restart Apache 2 and MySQL:
```
/etc/init.d/mysql restart
```

edited Jun 05 '18 at 04:31

slier

6,511
6
36
55

answered Feb 10 '12 at 18:11

jane

751
5
2

3

Maybe this approach may not be the right one. Think about the situation of having a server with UTC but your application is serving data to a country on UTC -0600. To adjust the timezone for MySQL, could be much better. – ivanleoncz Mar 18 '17 at 00:06
2

Especially if you work in an area that covers multiple timezones. – Alexis Wilke May 29 '17 at 17:47

score 66 · Answer 4 · answered May 31 '09 at 00:08

66

To set it for the current session, do:

SET time_zone = timezonename;

answered May 31 '09 at 00:08

James Skidmore

49,340
32
108
136

17

SELECT @@session.time_zone; – James Skidmore May 31 '09 at 00:18
1

I'm trying fix some errors on my system, and I need to set my time_zone to UTC, not GMT. Do you know if I set to '-0:00' or '+00:00' this is a UTC annotation or GMT annotation? I'm kind of NOT finding this specific information. Cheers! – rafa.ferreira May 16 '11 at 16:32
@Castanho, I'm pretty sure either one will work fine. Check out the explanation on this question: http://stackoverflow.com/questions/3466630/mysql-default-time-format-utc-or-gmt – James Skidmore May 16 '11 at 17:26
The value for the time zone can be the same as the one set in PHP, such as `SET time_zone = 'America/Boise'`. Thanks for the answer, James Skidmore! – Adam Fowler Feb 17 '13 at 03:46
For names to work in this context they'll need to have been loaded into the mysql time zone information tables. To the best of my knowledge this is NOT done by default in most installations; instructions on loading them from your system's zoneinfo tables can be found here: http://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html – Don Jun 19 '14 at 02:20
Does this setting get lost if they restart the server? – the_nuts Oct 18 '14 at 17:24
1

@the_nuts yes, the `SET time_zone = 'UTC';` setting gets lost during server restart – Timo Huovinen Nov 08 '16 at 09:55

score 58 · Answer 5 · edited Nov 28 '16 at 13:12

58

Simply run this on your MySQL server:

SET GLOBAL time_zone = '+8:00';

Where +8:00 will be your time zone.

edited Nov 28 '16 at 13:12

Peter Mortensen

30,738
21
105
131

answered Apr 17 '13 at 17:08

Rico Chan

2,226
2
25
32

21

Note, that this is only temporary until you restart Mysql – rubo77 Mar 27 '17 at 04:17
Rarely does one have superuser privileges when connecting to a DB. Setting `@@session.time_zone` as described in other answers is a much better route. – colm.anseo Jun 05 '19 at 17:00
2

This would become inaccurate once daylight savings time hits as you'd go from `+8:00` to `+9:00` (for timezones that use DST). – PromInc Oct 30 '20 at 12:35

score 21 · Answer 6 · edited Nov 28 '16 at 13:09

21

This work for me for a location in India:

SET GLOBAL time_zone = "Asia/Calcutta";
SET time_zone = "+05:30";
SET @@session.time_zone = "+05:30";

edited Nov 28 '16 at 13:09

Peter Mortensen

30,738
21
105
131

answered Oct 03 '16 at 12:55

Swapnil Bijwe

347
2
7

you need to run this as query on mysql or write under my.conf with following syntax default-time-zone = '+05:30' – Swapnil Bijwe Jan 10 '17 at 06:58
should i re-run the code after restart the server ? – AdDev Jan 02 '21 at 12:40

hamza saber · Answer 7 · 2020-04-19T17:45:20.823

19

This is a 10 years old question, but anyway here's what worked for me. I'm using MySQL 8.0 with Hibernate 5 and SpringBoot 4.

I've tried the above accepted answer but didn't work for me, what worked for me is this:

db.url=jdbc:mysql://localhost:3306/testdb?useSSL=false&serverTimezone=Europe/Warsaw

If this helps you don't forget to upvote it :D

edited Apr 19 '20 at 17:45

answered Sep 27 '19 at 20:04

hamza saber

511
1
4
18

score 16 · Answer 8 · edited Mar 30 '17 at 20:39

Keep in mind, that 'Country/Zone' is not working sometimes... This issue is not OS, MySQL version and hardware dependent - I've met it since FreeBSD 4 and Slackware Linux in year 2003 till today. MySQL from version 3 till latest source trunk. It is ODD, but it DOES happens. For example:

root@Ubuntu# ls -la /usr/share/zoneinfo/US
total 8

drwxr-xr-x  2 root root 4096 Apr 10  2013 .
drwxr-xr-x 22 root root 4096 Apr 10  2013 ..
lrwxrwxrwx  1 root root   18 Jul  8 22:33 Alaska -> ../SystemV/YST9YDT
lrwxrwxrwx  1 root root   21 Jul  8 22:33 Aleutian -> ../posix/America/Adak
lrwxrwxrwx  1 root root   15 Jul  8 22:33 Arizona -> ../SystemV/MST7
lrwxrwxrwx  1 root root   18 Jul  8 22:33 Central -> ../SystemV/CST6CDT
lrwxrwxrwx  1 root root   18 Jul  8 22:33 Eastern -> ../SystemV/EST5EDT
lrwxrwxrwx  1 root root   37 Jul  8 22:33 East-Indiana -> ../posix/America/Indiana/Indianapolis
lrwxrwxrwx  1 root root   19 Jul  8 22:33 Hawaii -> ../Pacific/Honolulu
lrwxrwxrwx  1 root root   24 Jul  8 22:33 Indiana-Starke -> ../posix/America/Knox_IN
lrwxrwxrwx  1 root root   24 Jul  8 22:33 Michigan -> ../posix/America/Detroit
lrwxrwxrwx  1 root root   18 Jul  8 22:33 Mountain -> ../SystemV/MST7MDT
lrwxrwxrwx  1 root root   18 Jul  8 22:33 Pacific -> ../SystemV/PST8PDT
lrwxrwxrwx  1 root root   18 Jul  8 22:33 Pacific-New -> ../SystemV/PST8PDT
lrwxrwxrwx  1 root root   20 Jul  8 22:33 Samoa -> ../Pacific/Pago_Pago
root@Ubuntu#

And a statement like that is supposed to work:

SET time_zone='US/Eastern';

But you have this problem:

Error Code: 1298. Unknown or incorrect time zone: 'EUS/Eastern'

Take a look at the subfolder in your zone information directory, and see the ACTUAL filename for symlink, in this case it's EST5EDT. Then try this statement instead:

SET time_zone='EST5EDT';

And it's actually working as it is supposed to! :) Keep this trick in mind; I haven't seen it to be documented in MySQL manuals and official documentation. But reading the corresponding documentation is must-do thing: MySQL 5.5 timezone official documentation - and don't forget to load timezone data into your server just like that (run as root user!):

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql

Trick number one - it must be done exactly under MySQL root user. It can fail or produce non-working result even from the user that has full access to a MySQL database - I saw the glitch myself.

Please tell me your uname -a and further details - have some working cases on Ubuntu desktop and server. — Alexey Vesnin, Apr 04 '14 at 15:02

score 13 · Answer 9 · answered May 31 '09 at 00:09

You can specify the server's default timezone when you start it, see http://dev.mysql.com/doc/refman/5.1/en/server-options.html and specifically the --default-time-zone=timezone option. You can check the global and session time zones with

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

set either or both with the SET statement, &c; see http://dev.mysql.com/doc/refman/5.1/en/time-zone-support.html for many more details.

MeKoo Solutions · Answer 10 · 2017-09-29T09:20:09.207

8

If you're using PDO:

$offset="+10:00";
$db->exec("SET time_zone='".$offset."';");

If you're using MySQLi:

$db->MySQLi->query("SET time_zone='".$offset."';");

More about formatting the offset here: https://www.sitepoint.com/synchronize-php-mysql-timezone-configuration/

edited Sep 29 '17 at 09:20

answered Sep 29 '17 at 09:06

MeKoo Solutions

271
6
5

score 6 · Answer 11 · answered Apr 28 '20 at 10:01

6

Edit the MySQL config file

sudo nano /etc/mysql/my.cnf

Scroll and add these to the bottom. Change to relevant time zone

[mysqld]
default-time-zone = "+00:00"

Restart the server

sudo service mysql restart

answered Apr 28 '20 at 10:01

Ivan_ug

2,467
2
17
18

score 5 · Answer 12 · answered Mar 10 '18 at 13:42

Ancient question with one more suggestion:

If you've recently changed the timezone of the OS, e.g. via:

unlink /etc/localtime
ln -s /etc/usr/share/zoneinfo/US/Eastern /etc/localtime

... MySQL (or MariaDB) will not notice until you restart the db service:

service mysqld restart

(or)

service mariadb restart

score 5 · Answer 13 · answered Jul 08 '19 at 01:38

First to figure out what the time_zone is you can query

SHOW VARIABLES LIKE '%time_zone%';

Your output should be something similar as follows

**Variable_name**     **Value**
system_time_zone      CDT
time_zone             SYSTEM

Then if you want to confirm that you are in say some time zone like CDT instead of something like EST you can check what time it thinks your machine is in by saying

SELECT NOW();

If this is not the time you want you need to change it... all you need to do is SET time_zone = timezone_name. Make sure it is one that is in Continent/City format.

If you are on a shared server because you have a hosting service please refer to these answers regarding changing the php.ini file or the .htaccess file.

I've tried `mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql -p E` first and then `SET time_zone = timezone_name` worked fine. — Ali Turki, Aug 03 '19 at 00:17

score 5 · Answer 14 · answered Dec 30 '21 at 21:43

if you use of named time-zone results in an error:

mysql> SET GLOBAL time_zone = "Asia/Bangkok";    
ERROR 1298 (HY000): Unknown or incorrect time zone: 'Asia/Bangkok'

you can try:

mysql_tzinfo_to_sql tz_file tz_name | mysql -u root -p mysql

and then:

SET GLOBAL time_zone = "Asia/Bangkok";
SET time_zone = "+07:00";
SET @@session.time_zone = "+07:00";

check what time is it:

SELECT NOW();

ref: https://dev.mysql.com/doc/refman/5.7/en/time-zone-support.html#time-zone-installation

score 4 · Answer 15 · answered Nov 03 '12 at 03:48

4

If you are using the MySql Workbench you can set this by opening up the administrator view and select the Advanced tab. The top section is "Localization" and the first check box should be "default-time-zone". Check that box and then enter your desired time zone, restart the server and you should be good to go.

answered Nov 03 '12 at 03:48

Taylor Lafrinere

3,084
18
27

2

The issue is related to MySQL, not to a particular program. – fedorqui Sep 16 '13 at 13:34
4

Found nothing like that. – Kzqai Jun 21 '16 at 20:51
1

Nothing like that – Green Nov 05 '16 at 02:28
For MySQL Workbench 6.3: Instance => Options file => General => International – paulus Jan 10 '17 at 11:39
7

[_UPDATE for MySQL Workbench **8.0**_] Select "Server" => "Options File", and on the "General" _tab_ see below the "International" _section_. There will be "default-time-zone" checkbox along with related field. So you can set the _default time zone_ value there. – informatik01 Dec 05 '18 at 10:29

score 4 · Answer 16 · answered Jun 21 '19 at 11:04

To set the standard time zone at MariaDB you have to go to the 50-server.cnf file.

sudo nano /etc/mysql/mariadb.conf.d/50-server.cnf

Then you can enter the following entry in the mysqld section.

default-time-zone='+01:00'

Example:

#
# These groups are read by MariaDB server.
# Use it for options that only the server (but not clients) should see
#
# See the examples of server my.cnf files in /usr/share/mysql/
#

# this is read by the standalone daemon and embedded servers
[server]

# this is only for the mysqld standalone daemon
[mysqld]

#
# * Basic Settings
#
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

### Default timezone ###
default-time-zone='+01:00'

# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.

The change must be made via the configuration file, otherwise the MariaDB server will reset the mysql tables after a restart!

score 3 · Answer 17 · answered Sep 29 '20 at 08:11

3

From MySQL Workbench 8.0 under the server tab, if you go to Status and System variables you can set it from here.

answered Sep 29 '20 at 08:11

Alison W

41
1

score 3 · Answer 18 · answered Feb 21 '21 at 14:18

You can do this easily by changing the OS time zone if match your scenario.

In Ubuntu, to list time zones, run this command

sudo timedatectl list-timezones

To change the OS time zone, run this command with your timezone

timedatectl set-timezone America/New_York

Check The OS time zone, run

date

Then restart the MySQL

sudo service mysql restart

To Chek time zone in MySQL, login and run

SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP);

score 2 · Answer 19 · answered Jan 08 '21 at 10:32

2

Set MYSQL timezone on server by logging to mysql server there set timezone value as required. For IST

SET SESSION time_zone = '+5:30';

Then run SELECT NOW();

answered Jan 08 '21 at 10:32

Rashi Goyal

933
9
15

score 1 · Answer 20 · edited Oct 17 '18 at 06:25

1

You have to set up the your location timezone. So that follow below process
Open your MSQLWorkbench write a simple sql command like this;

select now();

And also your url could be like this;

url = "jdbc:mysql://localhost:3306/your_database_name?serverTimezone=UTC";

edited Oct 17 '18 at 06:25

LuFFy

8,799
10
41
59

answered Jul 29 '17 at 16:35

harun ugur

1,718
18
18

@LuFFy this is what I was wondering about, so for each db-connect the time-zone must be set IF we are using the session-scope time-zone and not the 'global'-scope time-zone. Its good to use session-scope if the app can have users in different time-zones, right? – Valter Ekholm Nov 13 '19 at 18:58

score 0 · Answer 21 · answered Aug 27 '19 at 18:25

0

On Windows (IIS) in order to be able to SET GLOBAL time_zone = 'Europe/Helsinki' (or whatever) the MySQL time_zone description tables need to be populated first.

I downloaded these from this link https://dev.mysql.com/downloads/timezones.html

After running the downloaded SQL query I was able to set the GLOBAL time_zone and resolve the issue I had where SELECT NOW(); was returning GMT rather than BST.

answered Aug 27 '19 at 18:25

Stewart Kirkpatrick

44
2

I could use the number format "+01:00" instead of "Europe/Stockholm" so I didn't need to dowload time_zone description tables, I think. – Valter Ekholm Nov 13 '19 at 18:54

score 0 · Answer 22 · answered Nov 18 '19 at 08:14

In my case, the solution was to set serverTimezone parameter in Advanced settings to an appropriate value (CET for my time zone).

As I use IntelliJ, I use its Database module. While adding a new connection to the database and after adding all relevant parameters in tab General, there was an error on "Test Connection" button. Again, the solution is to set serverTimezone parameter in tab Advanced.

score 0 · Answer 23 · answered Jun 11 '20 at 10:31

If anyone is using GoDaddy Shared Hosting, you can try for following solution, worked for me.

When starting DB connection, set the time_zone command in my PDO object e.g.:

$pdo = new PDO($dsn, $user, $pass, $opt);
$pdo->exec("SET time_zone='+05:30';");

Where "+05:30" is the TimeZone of India. You can change it as per your need.

After that; all the MySQL processes related to Date and Time are set with required timezone.

Source : https://in.godaddy.com/community/cPanel-Hosting/How-to-change-TimeZone-for-MySqL/td-p/31861

How do I set the time zone of MySQL?

23 Answers23

There are three places where the timezone might be set in MySQL:

In the file "my.cnf" in the [mysqld] section

@@global.time_zone variable

@@session.time_zone variable

To get the current timezone offset as `TIME`

To get the current UNIX timestamp:

To get the timestamp column as a UNIX timestamp

To get a UTC datetime column as a UNIX timestamp

Linked

Related

How do I set the time zone of MySQL?

23 Answers23

There are three places where the timezone might be set in MySQL:

In the file "my.cnf" in the [mysqld] section

@@global.time_zone variable

@@session.time_zone variable

To get the current timezone offset as TIME

To get the current UNIX timestamp:

To get the timestamp column as a UNIX timestamp

To get a UTC datetime column as a UNIX timestamp

Linked

Related

To get the current timezone offset as `TIME`