Description of problem: Reports created always shows the UTC time for `date and time` fields in a report. Note: Appliance Time Zone is set to "(GMT+5:30) Kolkata" in 'Configuration' - See screenshot `Report1-UTC.png` which shows the `Date Created` field in UTC. - Downloaded PDF report and shows UTC time in the report. (See attachment, Report2-UTC.pdf) - Downloaded CSV report and shows IST time in the report. (See attachment, Report3.CSV.pdf) Version-Release number of selected component (if applicable): 5.10.6.1 How reproducible: Always Steps to Reproduce: 1. Set Appliance time zone to your timezone in appliance Configuration other than UTC 2. Create a report including `date and time` fields 3. Queue and download PDF and CSV format of the same reports. 4. Notice the timezone different in the downloaded reports. Actual results: Report fields are using UTC timezone Expected results: Reports should show the timezone configured in "Appliance Time Zone" Additional Information: I have created this separate bugzilla based on comment: https://bugzilla.redhat.com/show_bug.cgi?id=1758549#c7
Hey Rahul, could I please ask you to retest on a later 5.10? I don't think you'll see the issue on 5.10.11 or 5.10.12
I can't reproduce this on up-to-date master. It's in UTC because the zone was wrong pre merge of https://github.com/ManageIQ/manageiq/pull/19285. I think any version of 19285 will show the correct timezone, and I think this is a dup of https://bugzilla.redhat.com/show_bug.cgi?id=1743535.
* sorry, any build version that includes 19825
Drew, Are we expecting to merge the fix - https://github.com/ManageIQ/manageiq/pull/19285 with 5.10.x ?
Oh, I forgot it hadn't been backported yet. Yes, sorry.