search

MariaDB / mariadb-docker

Docker Official Image packaging for MariaDB
https://mariadb.org
GNU General Public License v2.0
770 stars 438 forks source link

Problem with MariaDB Time and Date #440

Closed Chris91550 closed 2 years ago

Chris91550 commented 2 years ago

Hello ! I've got a problem with my mariadb the time and data are not correct i've set the Timezone that I wanted but there is no changes:

The wrong date and time image

The correct date and time image

grooverdan commented 2 years ago 
$ podman run --rm  --env MARIADB_ROOT_PASSWORD=bob --name m106 -d mariadb:10.6 --default-time-zone=Europe/Paris
015391a31f28d9c5391972f2be95d046b9ec43e5530ffd67fbeb58cee043f9a8

$ podman exec m106 mysql -pbob -e 'select now()'; TZ=Europe/Paris date
now()
2022-06-15 18:09:22
Wed 15 Jun 2022 18:09:23 CEST

Keep in mind time_zone is a Global and Session variable. Meaning if you do set global time_zone=Europe/Paris, this doesn't impact the existing sessions, only new sessions/connections made after the global time_zone was changed. How are you setting the timezone?

iangilfillan commented 2 years ago

4 days out is unlikely to be a timezone issue. Is the time on the actual machine itself correctly set?

grooverdan commented 2 years ago

Yep, A StackOverflow commenter came to the same conclusion.

Happy to take bug reports, but I don't think this is one.