Server timezone :
timedatectl
Local time: Wed 2023-06-21 15:36:39 WEST
Universal time: Wed 2023-06-21 14:36:39 UTC
RTC time: Wed 2023-06-21 14:36:39
Time zone: Europe/Lisbon (WEST, +0100)
System clock synchronized: yes
MYSQL
MariaDB [(none)]> select now();
+---------------------+
| now() |
+---------------------+
| 2023-06-21 15:38:25 |
+---------------------+
1 row in set (0.001 sec)
MariaDB [(none)]> SELECT @@global.time_zone;
+--------------------+
| @@global.time_zone |
+--------------------+
| SYSTEM |
+--------------------+
1 row in set (0.000 sec)
MariaDB [(none)]> SELECT @@global.system_time_zone;
+---------------------------+
| @@global.system_time_zone |
+---------------------------+
| WEST |
+---------------------------+
1 row in set (0.000 sec)
PHP
cat /etc/php/8.0/cli/php.ini | grep -i timezone
; Defines the default timezone used by the date functions
; http://php.net/date.timezone
date.timezone = Europe/Lisbon
#OSTICKET
Default Time Zone: Europe/Lisbon
Profile Timezone : Europe/Madrid
As you can see Profile Time zone was not correct (and we believe that all agents have this setting to Europe/Madrid insteed of Europe/Lisbon), so i've made the correction on my profile and we are going to try once more.