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
How to fix LastModifiedDateTime in the database?
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.
Userlevel 2
Found the solution:
SELECT LastModifiedDateTime AT TIME ZONE 'UTC' AT TIME ZONE 'Central Standard Time' from SOLIne
Thanks mbridges00 for your help!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.