1490652 - Timestamp in comments is UTC time but says CEST

Status: UNCONFIRMED

(Bugzilla :: Bugzilla-General, defect)

Description

[Michael]

User Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36

Steps to reproduce:

Bugzilla on Ubuntu 18.04 with PostgreSQL 10.4 database all on the same server. Local time on server is CEST:

root@demk-srv-021:~# date
Mi 12. Sep 14:24:03 CEST 2018

Bugzilla shows correct time in CEST when I click Home -> Open bugs assigne to me.

Time preferences I tried are "Same as Server" or UTC+2
Then at 16:24:03 comment on a bug.


Actual results:

Comment shows the timestamp local time -2 hours i.e. it shows

Mi 12. Sep 14:24:03 CEST 2018


Expected results:

It should show

Mi 12. Sep 16:24:03 CEST 2018

Comment 1

[Thomas D. (:thomas8)]

Worksforme, see Bug 11383 Comment 172.

Michael, do you still see this bug?

Comment 2

[Michael]

Hi Thomas,

yes, but I'm still on the same Bugzilla Version 5.0.4. It's not a big problem. I will probably upgrade to the next LTS Ubuntu version and whatever Bugzilla version that brings sometime next year.

Comment 3

[Steve]

I am having this same problem.
Ubuntu 20.04.6 LTS
MySQL 5.7.44-google-log - (Google)
Bugzilla 5.0.6

Server time is correctly displaying as CDT:
$ date
Wed 24 Apr 2024 04:01:27 PM CDT

If I set my time zone preferences to the default (same as server), Bugzilla gives the wrong time. It gives UTC time but labels it as CDT time:
Last modified: 2024-04-24 21:11:37 CDT

For comparison, I have a WordPress site on the same server, and times are accurate on that site.

Comment 4

[Dave Miller [:justdave]]

I believe most of the date code in Bugzilla asks the database server for the date. What is the DB reporting?

SELECT DATE(); should show you the current time on the DB server, but not the time zone.

SELECT TIMEDIFF(NOW() - UTC_TIMESTAMP); should tell you the time zone offset.

Comment 5

[Dave Miller [:justdave]]

Actually, Bugzilla is fetching the time from the DB server as UTC and not getting the time zone from there.

There's a user preference for the time zone so each Bugzilla account should be able to set it themselves. The site-wide default is set in the Default Preferences section in Administration.