Time Zone used in Event List
Posted: Wed Apr 24, 2024 3:59 pm
I want the event list to show local time, not UTC.
Complaints about this seem to go back to 2006, and apparently the problem must not impress the developers since it seems to have been pretty much ignored.
There is a config option for system time zone (TIMEZONE) which apparently does not affect the event list display.
Semantically, just from a common-sense point of view, I am not trying to change the system time, I am trying to alter the display time zone. I'm not sure what TIMEZONE does, but it is set to my local zone, and isn't fixing the problem. I assume that TIMEZONE was what was set when I installed and specified my time zone as PST/PDT.
Looking over the history of this problem on multiple forums I have found:
1) In desperation some folks have taken to setting the zone in /etc/php/8.2/apache2/php.ini - sadly this changes the zone for every php program running on this server under Apache. I don't want to change the environment on all programs. And I don't want this setting to be lost if Apache upgrades to, e.g., 8.3. This is the wrong way to control Zoneminder IMHO.
2) One person changed the database time zone in mysql. This also seems to me to be a huge mistake - I don't want to change the database system parameters, and I don't even want to change the format of dates/times stored in a database - I just want to specify the display format. Hopefully the database has integers representing the number of seconds in the epoch which is a zone independent integer.
It appears that I need to file a feature request, but I'm not sure whether there is some opposition to getting this right. Or is this a bug because TIMEZONE should do this?
Comments?
Complaints about this seem to go back to 2006, and apparently the problem must not impress the developers since it seems to have been pretty much ignored.
There is a config option for system time zone (TIMEZONE) which apparently does not affect the event list display.
Semantically, just from a common-sense point of view, I am not trying to change the system time, I am trying to alter the display time zone. I'm not sure what TIMEZONE does, but it is set to my local zone, and isn't fixing the problem. I assume that TIMEZONE was what was set when I installed and specified my time zone as PST/PDT.
Looking over the history of this problem on multiple forums I have found:
1) In desperation some folks have taken to setting the zone in /etc/php/8.2/apache2/php.ini - sadly this changes the zone for every php program running on this server under Apache. I don't want to change the environment on all programs. And I don't want this setting to be lost if Apache upgrades to, e.g., 8.3. This is the wrong way to control Zoneminder IMHO.
2) One person changed the database time zone in mysql. This also seems to me to be a huge mistake - I don't want to change the database system parameters, and I don't even want to change the format of dates/times stored in a database - I just want to specify the display format. Hopefully the database has integers representing the number of seconds in the epoch which is a zone independent integer.
It appears that I need to file a feature request, but I'm not sure whether there is some opposition to getting this right. Or is this a bug because TIMEZONE should do this?
Comments?