@mkassir95 opened this Issue on December 10th 2021

I am using matomo latest version 4.6.2 .
I feel that that the time zone is not accurate , it is behind the real time zone by two hours (please look at my PC clock)
image

@sgiehl commented on December 10th 2021 Member

Hi @mkassir95. As the text says, the displayed time is UTC. So guess you are having a timezone with UTC+2?

@mkassir95 commented on December 10th 2021

yes lebanon timezone is UTC+2
image
How can I adjust this ?

@sgiehl commented on December 10th 2021 Member

You do not need to adjust anything. If you select your timezone in the drop down, this timezone will be used for newly created websites. The time displayed in the description is for informal purpose only and will always display the UTC time.

@mkassir95 commented on December 10th 2021

but the server time saved in the database is UTC and not the select zone time , in the dashboard the time is correct UTC+2 but in the database the time is UTC

@mkassir95 commented on December 10th 2021

image
image

@mkassir95 commented on December 10th 2021

The database is UTC while the dashboard is UTC+2

@sgiehl commented on December 10th 2021 Member

Yes. The database is always using UTC. The dashboard should use the timezone that is configured for the site.

@mkassir95 commented on December 10th 2021

Then , is there a solution for this in order to read the real time form the database without workaround?

@sgiehl commented on December 10th 2021 Member

I think I don't understand your problem. If you want your data being processed in UTC, simply select UTC as timezone for the website.

@mkassir95 commented on December 10th 2021

I need to generate custom reports and I do not want use the reports generated by the dashboard . So , I will fetch the data from the database to generate my custom reports and I will not use the dashboard . For this I will be facing a problem because the UTC is used as a timezone in the database even though I selected my local timezone

@sgiehl commented on December 13th 2021 Member

UTC is used in that database for a very good reason and this won't be changed. If you want to generate reports using database data directly, you need to adjust the returned datetime values on your own. All reports returned by the UI or the API should do that automatically for you.

This Issue was closed on December 13th 2021
Powered by GitHub Issue Mirror