server_time/visit_*_action_time's TimeZone


#1

Can we log server_time/visit_*_action_time in another timezone?

I have it in UTC in my database, I imagine we have to in order to use the timezones in the dashboard, but is it possible to change it?


(Matthieu Aubry) #2

The values in the database are always stored in UTC, but you can change the time zone for each website, see FAQ: How to - Analytics Platform - Matomo


#3

Yes I read this already, but my issue is not that I haven’t the good timezones for my website, I just want to avoid re-adjusting the data when I look at it directly in my database. To do this, I was searching how to make data to be inserted in another timezone (mine).
I think that’s not a feature in Piwik, but I was hoping you could guide me to a file to modify in order to do it.

Thanks


(Matthieu Aubry) #4

No that cannot be a feature request for Piwik. It is on purpose that we store in UTC, this is best practise of database engineering (it avoids many complicated problems). So we won’t change it… maybe you can use the Piwik Analytics APIs instead of direct DB access (it will show time in your website’s timezone)