SQL database date and Enterprise date don't match

Anonymous User · ‎01-05-2022

Hello,

We are having issues with the date/time. We have date time coming from a sql database/geodatabase and when we open the data in the Enterprise that date/times do not match. This is from SQL

for example, the middle date 2020-01-02 02:43:00.000 translates to 1/1/2020, 6:43 pm.

This is the enterprise date.

As you can see the date and time change. Does anyone have an idea how to fix this? Thank you.

Annette

NeumanAndrew · ‎01-05-2022

It's most likely that your SQL Server is using your default time zone and your Enterprise is configured to use GMT which is the default for web services. We ran into this issue when we first start using Collector to capture data in the field and the times didn't align when I imported the data into a different SQL server database.

View solution in original post

TanuHoque · ‎01-05-2022

@Anonymous User

Please check the Time Zone property for the service in the Manager site, and make sure it is set.

also, check out this tech session discussion how date/time values are worked across our platform.

https://www.youtube.com/watch?v=esb8X-1TtPk

NeumanAndrew · ‎01-05-2022

It's most likely that your SQL Server is using your default time zone and your Enterprise is configured to use GMT which is the default for web services. We ran into this issue when we first start using Collector to capture data in the field and the times didn't align when I imported the data into a different SQL server database.