Changing timezone via KIWI_TIME_ZONE and KIWI_USE_TZ does not change the timezone in grid datetime data (Dockerized KIWI)

[horvathmilcsi]

Changing timezone via KIWI_TIME_ZONE and KIWI_USE_TZ does not change the timezone in grid view datetime data, for example on webpage .../cases/search/

Important note: the timezoen does indeed changed on the top right corner of the screen, and even on database data displayed on a siingle-record view, for example on webpage .../case/66/

So the problem only shows up in grid views.

In my docker-compose.yml I set these variables:
KIWI_TIME_ZONE: Europe/Budapest
KIWI_USE_TZ: True

this is my docker-compose.yml:

version: '2'

services:
db:
container_name: kiwi_db
image: mariadb:latest
command:
--character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci
volumes:
- db_data:/var/lib/mysql
restart: always
environment:
# checkov:skip=CKV_SECRET_6:Base64 High Entropy String
MYSQL_ROOT_PASSWORD: xxx
MYSQL_DATABASE: kiwi
MYSQL_USER: kiwi
MYSQL_PASSWORD: xxx

web:
    container_name: kiwi_web
    depends_on:
        - db
    restart: always
    image: pub.kiwitcms.eu/kiwitcms/kiwi:latest
    ports:
        - 80:8080
        - 443:8443
    volumes:
        - uploads:/Kiwi/uploads:Z
    environment:
        KIWI_DB_HOST: db
        KIWI_DB_PORT: 3306
        KIWI_DB_NAME: kiwi
        KIWI_DB_USER: kiwi
        KIWI_DB_PASSWORD: xxx
        KIWI_TIME_ZONE: Europe/Budapest
        KIWI_USE_TZ: "True"
        DEFAULT_FROM_EMAIL: xxx
        SERVER_EMAIL: xxx
        EMAIL_SUBJECT_PREFIX: "[Kiwi-TCMS]"
        EMAIL_HOST: xxx
        EMAIL_PORT: xxx
        EMAIL_USE_TLS: False
        DEBUG: False
        TZ: Europe/Budapest
    cap_drop:
      - ALL

volumes:
db_data:
uploads:

I use Dockerized KIWI version 14.3 (via docker pull pub.kiwitcms.eu/kiwitcms/kiwi:latest )

Steps to Reproduce

spin up KIWI TCMS using the above docker-comopose.yml
(set the passwords correctly)
Navigate to .../cases/search/ page
start another browser window and navigate to the individual test case record view page, for example .../case/1/
compare the 2 datetime data: are they showing the same time?

Actual results

#1 on the top of the screen the date is correct timezone (Europe/Budapest)
#2 on the .../cases/search/ page the time is in UTC timezone (2025-08-22T11:35:13.255Z), which is wrong
#3 if i click on the name of that particular test case, and enter the record view for case 66, then the .../case/66/ page shows Budapest timezone (2025. augusztus 22. 13:35) which is correct.

Expected results

I expect that all 3 cases show Budapest timezone.

[HuntTheSun]

I have the exact same setup, except "Europe/Berlin".
The results are the same for me, /runs/search/ also shows the incorrect time, but /runs/1234 is correct
The db stores the correct UTC timestamp, my guess is that the table in the search doesnt convert the timestamp to local TZ.