We have LastModifiedDateTime in the database tables in the future. On the application level it’s correct.
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/de5087e8-ec6c-4cc1-b723-b254188e0caf.png)
![](https://uploads-us-west-2.insided.com/acumatica-en/attachment/3a9f2214-eebb-40d8-bad9-d93367cf3143.png)
Database collation is SQL_Latin1_General_CP1_CI_AS. Our location - US, Central Time
We have LastModifiedDateTime in the database tables in the future. On the application level it’s correct.
Database collation is SQL_Latin1_General_CP1_CI_AS. Our location - US, Central Time
The datetime in the database is typically stored as UTC. There’s a lot of logic taking place depending on timezone setup on the user, tenant, etc. that converts to/from UTC time to local time zone visible on the screen.
Found the solution:
SELECT LastModifiedDateTime AT TIME ZONE 'UTC' AT TIME ZONE 'Central Standard Time' from SOLIne
Thanks mbridges00 for your help!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.