-
Type:
Bug
-
Resolution: Timed out
-
Priority:
Low
-
None
-
Affects Version/s: 7.6.9, 7.6.12, 7.13.1
-
Component/s: System Administration - General Configuration
-
None
-
7.06
-
1
-
Severity 3 - Minor
Issue Summary
When a date is entered by a date picker is then updated manually in the date field to only include 2-digit year, this date is stored as a negative epoch in the database.
One example of a date is a sprint start date.
Steps to Reproduce
- Go to the system advance settings.
- Change jira.date.picker.java.format to d/MMM/yyyy
- Change jira.date.picker.javascript.format to %e/%b/%Y
- Change jira.date.time.picker.java.format to dd/MMM/yyyy h:mm a
- Change jira.date.time.picker.javascript.format to %e/%b/%Y %I:%M %p
- Start a sprint with a custom duration
- Pick a date
- Update the date filled by the date picked to only include two digits in the year. For instance, from 28/Mar/2019 04:37 PM to 28/Mar/19 04:37 PM.
- Start the sprint
Expected Results
The sprint start date in the DB should be stored as if it was in the year 2019.
Actual Results
The sprint start date in the DB is stored as if the sprint started in the year 0019. Thus, it's a negative epoch.
# SELECT * FROM "AO_60DB71_SPRINT" WHERE "NAME"='Sample Sprint 4'; CLOSED | COMPLETE_DATE | END_DATE | GOAL | ID | NAME | RAPID_VIEW_ID | SEQUENCE | STARTED | START_DATE --------+---------------+-----------------+------+----+-----------------+---------------+----------+---------+----------------- t | 1553009870350 | -61559771220000 | | 9 | Sample Sprint 4 | 3 | | t | -61561067201237 (1 row)