Remove the additional 0s from the datetime field

Issue No: MFG-5134
Created 5/31/2023 2:52:42 AM
Type Feature
Priority Critical
Status Closed
Resolution Fixed
Fixed Version 19.1
Description *This issue relates to i21 Help Desk ticket:* [ HDTN-303558 - DB Restore Request for HDTN-295474|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-303558]   *This issue relates to i21 Help Desk ticket:* [ HDTN-295474 - Filter out the packaging materials from Production report|https://helpdesk.irely.com/iRelyi21live/#/HD/Ticket/?ticket=HDTN-295474]   *Steps:*   1. Query existing views.     *Issue:*   The datetime field is having additional 0s highlighted below. Please remove these 0s from all DATETIME field of the following views:   vyuMFGetProduction   vyuMFGetRMUsageByLot   vyuMFGetOverAndUnderWeight   vyuMFGetRMUsage   vyuMFGetReceiving   uspMFProductionReport   !pastedImage_d219326_0.png|height=290,width=550!     *Acceptance:*   Datetime field should not have trailing zeros.