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

 

 

NeumanAndrew

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.