[DMS-1496] Store time zone information with Date Time in DMS - Workterra Jira

Details

Type: New Feature
Status: Done
Priority: High
Resolution: Done
Affects Version/s: None
Fix Version/s: CBAT Offer Letter - Fall
Labels:
None

Company:
All Clients/Multiple Clients
Epic Link:
Integration with CBES

Sprint:
DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4
QA Estimates:
1

Description

Currently Date times across the system are being stored with local server time without timezone info. We should be storing dates in database with timezone information.

Task: Store all date times in DMS in UTC in Database.

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

Screenshot (289).png
129 kB
17/Sep/19 11:07 PM
Screenshot (290).png
137 kB
17/Sep/19 11:07 PM
Screenshot (291).png
117 kB
17/Sep/19 11:07 PM
Screenshot (292).png
121 kB
17/Sep/19 11:07 PM
Screenshot (293).png
132 kB
17/Sep/19 11:07 PM

Activity

Ascending order - Click to sort in descending order

Harshveer Singh (Inactive) created issue - 12/Jun/19 04:59 AM

Samir made changes - 13/Jun/19 12:19 AM

Field	Original Value	New Value
Assignee	Harshveer Singh [ harshveer.singh ]	Santosh [ santoshs ]

Samir made changes - 13/Jun/19 12:19 AM

Fix Version/s

CBAT Offer Letter - Fall [ 10607 ]

Samir made changes - 13/Jun/19 12:19 AM

Remaining Estimate		16h [ 57600 ]
Original Estimate		16h [ 57600 ]

Santosh (Inactive) made changes - 13/Jun/19 11:09 PM

Status

To Do [ 10000 ]

In Progress [ 3 ]

Santosh (Inactive) made changes - 16/Jun/19 09:59 PM

Status

In Progress [ 3 ]

Code Review [ 11801 ]

Samir made changes - 17/Jun/19 10:37 PM

Epic Link

DMS-480 [ 75973 ]

ShashiKant Mishra (Inactive) made changes - 23/Jun/19 10:15 PM

Sprint

DMS - Fall Sprint 5 [ 164 ]

DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 164, 165 ]

Samir made changes - 08/Jul/19 01:38 AM

Assignee

Santosh [ santoshs ]

Harshveer Singh [ harshveer.singh ]

ShashiKant Mishra (Inactive) made changes - 08/Jul/19 02:32 AM

Sprint

DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 164, 165 ]

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 164, 165, 166 ]

ShashiKant Mishra (Inactive) made changes - 22/Jul/19 03:21 AM

Sprint

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 164, 165, 166 ]

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 164, 165, 166, 167 ]

ShashiKant Mishra (Inactive) made changes - 05/Aug/19 02:12 AM

Sprint

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8 [ 164, 165, 166, 167 ]

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1 [ 164, 165, 166, 167, 173 ]

ShashiKant Mishra (Inactive) made changes - 19/Aug/19 02:33 AM

Sprint

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1 [ 164, 165, 166, 167, 173 ]

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 164, 165, 166, 167, 173, 174 ]

Raj Hawaldar (Inactive) made changes - 20/Aug/19 09:32 PM

Status

Code Review [ 11801 ]

In QA Testing [ 11901 ]

ShashiKant Mishra (Inactive) made changes - 30/Aug/19 09:30 PM

Sprint

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2 [ 164, 165, 166, 167, 173, 174 ]

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3 [ 164, 165, 166, 167, 173, 174, 177 ]

Harshveer Singh (Inactive) made changes - 10/Sep/19 09:30 PM

Assignee

Harshveer Singh [ harshveer.singh ]

Priya Dhamande [ priya.dhamande ]

ShashiKant Mishra (Inactive) made changes - 16/Sep/19 01:52 AM

Sprint

DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7, DMS - Fall Sprint 8, DMS - Gap Fall & Win Sprint 1, DMS - Gap Fall & Win Sprint 2, DMS - Gap Fall & Win Sprint 3, DMS - Gap Fall & Win Sprint 4 [ 164, 165, 166, 167, 173, 174, 177, 179 ]

Priya Dhamande (Inactive) made changes - 16/Sep/19 02:38 AM

QA Estimates

Priya Dhamande (Inactive) made changes - 16/Sep/19 04:30 AM

Remaining Estimate

16h [ 57600 ]

1h [ 3600 ]

Priya Dhamande (Inactive) made changes - 17/Sep/19 11:07 PM

Attachment		Screenshot (291).png [ 120020 ]
Attachment		Screenshot (290).png [ 120021 ]
Attachment		Screenshot (289).png [ 120022 ]
Attachment		Screenshot (293).png [ 120023 ]
Attachment		Screenshot (292).png [ 120024 ]

Priya Dhamande (Inactive) made changes - 17/Sep/19 11:10 PM

Resolution		Done [ 10000 ]
Status	In QA Testing [ 11901 ]	Done [ 10001 ]

Priya Dhamande (Inactive) made changes - 17/Sep/19 11:11 PM

Assignee

Priya Dhamande [ priya.dhamande ]

Akash Thakur [ akash.thakur ]

Priya Dhamande (Inactive) made changes - 23/Sep/19 11:08 PM

Assignee

Akash Thakur [ akash.thakur ]

Rohan J Khandave [ rohan.khandave ]

People

Assignee:: Rohan J Khandave (Inactive)

Reporter:: Harshveer Singh (Inactive)

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 12/Jun/19 04:59 AM

Updated:: 23/Sep/19 11:08 PM

Resolved:: 17/Sep/19 11:10 PM

Time Tracking

Estimated:

16h

Remaining:

Logged:

Not Specified