The date is not up to date in the database

The date is not up to date in the database… I have a shift of 2 hours compared to the date and time of my dedicated machine, how to configure it in AdonisJS?

1 Like

I believe the date settings has to be configured on the database server

What exactly are you expecting from Adonis in this case?

I’ve been added this config in my.cnf for MariaDB:

[mysqld]
default_time_zone=Europe/Paris

When I type SELECT NOW(); in MySQL console, I’ve the correct date and hour, but in database, I haven’t the right date/hour…

Thanks.

I am having this same issue. I changed timezone in Server with no avail. I haven’t changed the timezone in mysql yet, though.