topic SQL database date and Enterprise date don't match in ArcGIS Enterprise Questions

SQL database date and Enterprise date don't match

Anonymous User — Wed, 05 Jan 2022 17:54:42 GMT

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

Re: SQL database date and Enterprise date don't match

TanuHoque — Wed, 05 Jan 2022 18:12:29 GMT

@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

Re: SQL database date and Enterprise date don't match

NeumanAndrew — Wed, 05 Jan 2022 18:45:26 GMT

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.