Skip to main content
Solved

Show Date with Time in GI using SQL View

  • 29 July 2024
  • 1 reply
  • 51 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.

View original

dcomerford
Captain I
Forum|alt.badge.img+15

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.


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings