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
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.