SQL database date and Enterprise date don't match

[Anonymous User]

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

[TanuHoque]

@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 · Accepted solution]

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.