MariaDB – Setting Europe/Athens Timezone

mariadbtimezone

I am using Debian 8, mariadb 10.4, nginx 10.3, php7.3-fpm.
My timezone configuration was like this:

Debian: Europe/Athens ( through tzselect command )
PHP: Europe/Athens , Default timezone UTC
Mariadb: Europe/Athens

The problem:

My records where inserted on DATETIME fields with UTC timezone ( 3 hours earlier).

I guess it the default timezone on php that makes the problem, but I don 't know how to solve it.

Best Answer

DATETIME is like taking a picture of your local clock.

Check these:

SHOW VARIABLES LIKE '%zone%';

SELECT NOW();

If NOW() does not show Athens time, then something is set incorrectly.

Related Solutions

Sql-server – Figuring out database timezone

The easiest way I have used to see if any objects are using a particular command (e.g. those that use a local time zone, such as GETDATE() and CURRENT_TIMESTAMP) is syscomments. The text column of this table in SQL 2000 has the actual command that makes up the object.

The caveat to this is if the procedure was created using WITH ENCRYPTION you will not be able to see or check the text column. I believe something like this should return what you are looking for:

SELECT OBJECT_NAME(ID), Text
FROM syscomments
WHERE Text LIKE '%GetDate%'

MYSQL Timezone support

In order to timezone support to be around, the hosting company should have executed this:

mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql ...

The mysql_tzinfo_to_sql utility should load the time zones. Please make sure the host company has done this. If they can't or won't,

you could into Amazon EC2, you could have full access to MySQL and can run it yourself
Find a willing hosting company

BTW Here is the MySQL Documentation for CONVERT_TZ : http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_convert-tz

Best Answer

Related Solutions

Sql-server – Figuring out database timezone

MYSQL Timezone support

Related Question