Piwik_log_visit table related query

General questions
1

Hi everyone … I am new to piwik application. Pls let me know in which format the **location_ip** field values are stored in the table **piwik_log_visit**.

For Ex : 7f000000 value in the Db displayed as 127.0.0.0 and 00000000000000000000000000000000 value in the Db displayed as ::

2

Sure, see: How do I select IP addresses or Visitor ID directly from the database? - Analytics Platform - Matomo

3

Thanks very much Matthieu, You really made my day.

4

Hi Matthieu, I needed 1 more clarity wrt the Date and Time Displayed for each visitor Log.

For the server_time field in the piwik_log_visit db table, value stored as 2016-12-30 05:09:21
but in the front end its displayed as 2016-12-30 10:39:21, so may I know how this conversion is happening before displaying in the front end ??

Please revert back on the above.

Thanks,
Ravi Shankar S M

5

Hi Ravi, the datetime is stored as UTC. So you need to convert it to your website’s timezone manually (there are some MySQL functions to help with this)