Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1496

Store time zone information with Date Time in DMS

    Details

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

      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

        1. Screenshot (289).png
          Screenshot (289).png
          129 kB
        2. Screenshot (290).png
          Screenshot (290).png
          137 kB
        3. Screenshot (291).png
          Screenshot (291).png
          117 kB
        4. Screenshot (292).png
          Screenshot (292).png
          121 kB
        5. Screenshot (293).png
          Screenshot (293).png
          132 kB

          Activity

          Ascending order - Click to sort in descending order
          harshveer.singh Harshveer Singh (Inactive) created issue -
          samir Samir made changes -
          Field Original Value New Value
          Assignee Harshveer Singh [ harshveer.singh ] Santosh [ santoshs ]
          samir Samir made changes -
          Fix Version/s CBAT Offer Letter - Fall [ 10607 ]
          samir Samir made changes -
          Remaining Estimate 16h [ 57600 ]
          Original Estimate 16h [ 57600 ]
          Hide
          Permalink
          samir Samir added a comment -

          Jilna;Rohan J Khandave

          Show
          samir Samir added a comment - Jilna ; Rohan J Khandave
          SantoshS Santosh (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          SantoshS Santosh (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          samir Samir made changes -
          Epic Link DMS-480 [ 75973 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 5 [ 164 ] DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 164, 165 ]
          samir Samir made changes -
          Assignee Santosh [ santoshs ] Harshveer Singh [ harshveer.singh ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          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 ShashiKant Mishra (Inactive) made changes -
          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 ShashiKant Mishra (Inactive) made changes -
          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 ShashiKant Mishra (Inactive) made changes -
          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 Raj Hawaldar (Inactive) made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          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 Harshveer Singh (Inactive) made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Priya Dhamande [ priya.dhamande ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          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 [ 164, 165, 166, 167, 173, 174, 177 ] 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 Priya Dhamande (Inactive) made changes -
          QA Estimates 1
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 1h [ 3600 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          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 ]
          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Environment: Preprod
          Login: Admin and Candidate
          Browser: FF and Chrome

          Pages verified:
          1. Signer > Candidate Page
          2. Candidate > Profile Page
          3. Candidate > Attachment
          4. Candidate > Action documents
          5. Candidate > Reference documents

          Time displayed as per current time. Refer screen capture.
          So, marking jira done.

          Samir Akash Thakur Rohan J Khandave Sachin Hingole Hrishikesh Deshpande

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Environment: Preprod Login: Admin and Candidate Browser: FF and Chrome Pages verified: 1. Signer > Candidate Page 2. Candidate > Profile Page 3. Candidate > Attachment 4. Candidate > Action documents 5. Candidate > Reference documents Time displayed as per current time. Refer screen capture. So, marking jira done. Samir Akash Thakur Rohan J Khandave Sachin Hingole Hrishikesh Deshpande
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Akash Thakur [ akash.thakur ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Akash Thakur [ akash.thakur ] Rohan J Khandave [ rohan.khandave ]
          Transition Time In Source Status Execution Times
          Santosh (Inactive) made transition -
          To Do In Progress
          		1d 18h 10m 1
          Santosh (Inactive) made transition -
          In Progress Code Review
          		2d 22h 49m 1
          Raj Hawaldar (Inactive) made transition -
          Code Review In QA Testing
          		64d 23h 33m 1
          Priya Dhamande (Inactive) made transition -
          In QA Testing Done
          		28d 1h 37m 1

            People

            Assignee:
            rohan.khandave Rohan J Khandave (Inactive)
            Reporter:
            harshveer.singh Harshveer Singh (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 16h
                16h
                Remaining:
                Remaining Estimate - 1h
                1h
                Logged:
                Time Spent - Not Specified Time Not Required
                Not Specified