Daylight Saving

Questions related to using nuBuilder Forte.

Daylight Saving

Unread postby vario » Sat Nov 20, 2021 3:55 am

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.
vario
 
Posts: 76
Joined: Mon Dec 05, 2011 8:53 pm
Location: Newton Abbot, UK
nuBuilder Version: 4.5

Re: Daylight Saving

Unread postby kev1n » Mon Nov 22, 2021 12:53 am

Hi Neil,

Try replacing Line 48 in nucommon.php

Code: Select all
nuRunQuery("SET time_zone = '$zone'");
kev1n
nuBuilder Team
 
Posts: 2117
Joined: Mon Oct 15, 2018 2:13 am
nuBuilder Version: 4.5

Re: Daylight Saving

Unread postby vario » Wed Nov 24, 2021 7:12 pm

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

Neil.
vario
 
Posts: 76
Joined: Mon Dec 05, 2011 8:53 pm
Location: Newton Abbot, UK
nuBuilder Version: 4.5


Return to General

Who is online

Users browsing this forum: No registered users and 19 guests