Project versions timestamps are one day behind in the database
Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.
Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
The project versions dates in the database don't match the ones in the UI.
For instance, a version release date of 20/Dec/2017 will show as 12/19/2017 20:00:00 in the database.
Cause
The time in the database will account for the difference in number of hours between the timezone of the database server and the timezone of the Jira server.
Examples
| Jira timezone | DB timezone | Release date in UI | Release date/time in the DB |
|---|---|---|---|
| UTC | EST (not EDT) | 20/Dec/2017 | 12/19/2017 19:00:00 |
| CEST | CDT | 20/Dec/2017 | 12/19/2017 17:00:00 |
Note
Updating the timezone of the DB server will update the times in the DB.