log_conversion table is 1 hour off

boosis · June 13, 2011, 9:46am

Hi,
just checking the log_conversion table and realized the server_time is 1 hour off.
My server time is 2011-06-13 10:00:12 but the log_conversion entry for that moments shows 2011-06-13 09:00:12

is this a bug? or am i doing something wrong.

julienm · June 20, 2011, 12:38pm

If I’m not mistaken, dates/times are stored in UTC 0. In which timezone is your server configured ?

boosis · June 20, 2011, 12:52pm

It’s Europe/London if that’s what you are asking

julienm · June 20, 2011, 9:27pm

UTC+1 then.

If you have configured your site timezone to UTC+1 or London (in Piwik Settings) then everything looks good.