time zones in MariaDB

Joel Handler partagé ce idée il y a 36 jours
En analyse

When running the sql command
SET time_zone = 'America/New_York';
I am getting

Fatal error: Uncaught mysqli_sql_exception: Unknown or incorrect time zone: 'America/New_York'

According to my research

The error "Unknown or incorrect time zone: 'America/New_York'" in MariaDB occurs because the timezone tables in the mysql system database are created but not populated by default.
To resolve this, you need to load the timezone information from your operating system's zoneinfo database into MariaDB's system tables using the mariadb-tzinfo-to-sql utility. I am not aware of any vulnerability in loading the timezone file and having it would be most helpful.

Poster un commentaire
 
Joindre un fichier