Skip to main content
Answer

Show Date with Time in GI using SQL View

  • July 29, 2024
  • 1 reply
  • 80 views

Forum|alt.badge.img

I want to Show Date in GI as it is show in Production order detail
1. Production Order Detail
 

 

  1. In DAC i will use

     

  2. But in GI it is showing 

    which is show in GI so i will solve it and show 2:30 which is correct

  3. But in Postman it is showing wrong

     

Best answer by dcomerford

Both are correct Acumatica stored the time based on UTC in the database. When it presents it to you on the form/GI it will show it as per your timezone.

Postman is getting the raw data and does not convert it to your local timezone as it has no concept of a timezone.

1 reply

dcomerford
Captain II
Forum|alt.badge.img+15
  • Captain II
  • Answer
  • July 29, 2024

Both are correct Acumatica stored the time based on UTC in the database. When it presents it to you on the form/GI it will show it as per your timezone.

Postman is getting the raw data and does not convert it to your local timezone as it has no concept of a timezone.