Solved

Change SQL Server from UTC to LOCAL time

  • 22 November 2022
  • 2 replies
  • 165 views

Userlevel 4
Badge

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?

icon

Best answer by Leonardo Justiniano 22 November 2022, 17:03

View original

2 replies

Userlevel 7
Badge +15

HI @development93 

Here is an older article in the community that may help you:

https://community.acumatica.com/reports-and-generic-inquires-115/wrong-time-in-gi-because-of-daylight-saving-time-11282?postid=40852#post40852

Userlevel 6
Badge +4

Hi @development93 

 

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

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved