Hello,

We have a query which works fine on 2.2.4+ and returns the right date. However, when we upgraded to 2.5.2, the date is incorrect... always 1969-12-31 16:33:32

the timezone is correct. It works on 2.2.4+ but not our 2.5.2+ version

Here is the query

Select FROM_UNIXTIME(time, '%Y-%m-%d') AS 'Date', COUNT(FROM_UNIXTIME(time, '%Y-%m-%d')) AS 'Count'
From prefix_log
WHERE action= "login"
AND userid <>"123456"
GROUP BY FROM_UNIXTIME(time, '%Y-%m-%d')

Returns as:...

date count
1969-12-31 16:33:32 157
1969-12-31 16:33:32 500
1969-12-31 16:33:32 541
1969-12-31 16:33:32 752
1969-12-31 16:33:32 755
1969-12-31 16:33:32 709
1969-12-31 16:33:32 489
.....

weird ...