[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

Transition	Time In Source Status	Execution Times

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

To Do

In Progress

1d 18h 10m

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

In Progress

Code Review

2d 22h 49m

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

Code Review

In QA Testing

64d 23h 33m

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

In QA Testing

Done

28d 1h 37m

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