Daylight Saving
Posted: Fri Nov 19, 2021 7:25 pm
I am having trouble with queries for dates before the clocks went back at end of October.
In mysql and phpMyAdmin I run query 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.
In mysql and phpMyAdmin I run query
Code: Select all
select * from tc_positions where fixtime = '2021-10-25 06:32:21'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.