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
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
Best answer by nadiyahnatyuk58
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.