Due Date system field and all Date Picker custom fields are recalculated to UTC during CSV export

Issue Summary

"Due Date" system field and all "Date Picker" type custom fields are recalculated to UTC in CSV export file. Both "CSV (All fields)" and "CSV (Current fields)" export methods are affected. All other export methods available on the Issue Search page are not affected (HTML and XML export). The problem can be reproduced only in Jira 8.16.0 and 8.16.1, all older versions (including 8.15.1) are not affected.

Steps to Reproduce

1. Edit Jira issue and set some date in the "Due Date" system field. Alternatively, you can set some date in any "Date Picker" type custom field.
2. Go to Search Issues page and enter JQL that will list issue from step 1 as one of the results.
3. Export the results using the "CSV (All fields)" or "CSV (Current fields)" method.
4. Look into an exported CSV file to verify exported data.

Expected Results

Assuming that the date set in the "Due Date" system field or "Date Picker" custom field was 6th May 2021, the value in CSV export file should be: 06/May/21 12:00 AM.

Actual Results

Assuming, that Jira environment is configured for Sydney AEDT timezone (GMT+10), the actual result is: 05/May/21 2:00 PM. 10 hours are subtracted from the correct date (06/May/21 12:00 AM), so the time is recalculated from GMT+10 to UTC (GMT+0). Data stored in the database is the same across all impacted and not impacted Jira versions.

Attached Files

• Data from Jira 8.15.1 (date set in "Due Date" system field and "Test Date" date picker custom field was 6th May 2021):
  • "Database_data_8151.txt" - stored data is correct and the same as the one from Jira 8.16.1.
  • "JIRA_8151_CSV_export.csv" - exported data is showing the proper values in the "Due Date" system field and "Test Date" date picker custom field.
• Data from Jira 8.16.1 (date set in "Due Date" system field and "Test Date" date picker custom field was 6th May 2021):
  • "Database_data_8161.txt" - stored data is correct and the same as the one from Jira 8.15.1.
  • "JIRA_8161_CSV_export.csv" - exported data is showing the wrong (recalculated) values in the "Due Date" system field and "Test Date" date picker custom field.

Workaround

Custom fields using date time pickers are not affected by this (only date pickers). Using custom fields with date time pickers will export with the expected time.