Daylight Saving

[vario]

I am having trouble with queries for dates before the clocks went back at end of October.
In mysql and phpMyAdmin I run query

Code: Select all

select * from tc_positions where fixtime = '2021-10-25 06:32:21'

and I get one row as expected.
In nuBuilder I get no results, and only get the row if I use 05:32:21 as the time portion, so obviously it is something related to timezones. How come it works outside of nubuilder? I have set the correct timezone "Europe/London" in the Setup (and tried UTC & GMT to no effect). When querying recent data (i.e November) it all works fine.

Hope someone can point me in the right direction!

Neil.

[kev1n]

Hi Neil,

Try replacing Line 48 in nucommon.php

Code: Select all

nuRunQuery("SET time_zone = '$zone'");

[vario]

OK thanks that has fixed the issue for me (providing there are no unforseen consequences!)

Neil.