I am trying to find a way to change SQL server from using UTC time to Local time. This is because I need to be getting Local time when I pull data using ODATA via excel.
Is there a way to configure the SQL server from UTC to local time?
Solved
Change SQL Server from UTC to LOCAL time
Best answer by Leonardo Justiniano
Hi
Acumatica always stores dates in UTC time. But you can play with Acumatica to get the local time of the user session. Please take a look at this article (still valid)
Date Time Conversion
https://asiablog.acumatica.com/2019/02/generic-inquiry-tips-tricks.html
Michael
+17HI
Here is an older article in the community that may help you:
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
+4Hi
Acumatica always stores dates in UTC time. But you can play with Acumatica to get the local time of the user session. Please take a look at this article (still valid)
Date Time Conversion
https://asiablog.acumatica.com/2019/02/generic-inquiry-tips-tricks.html
Leo
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.