SQL database date and Enterprise date don't match

203
2
Jump to solution
01-05-2022 09:54 AM
AnnettePoole1
Occasional Contributor II

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

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

AnnettePoole1_1-1641405216865.pngThis 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

 

 

0 Kudos
1 Solution

Accepted Solutions
NeumanAndrew
New Contributor

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

2 Replies
TanuHoque
Esri Regular Contributor

@AnnettePoole1 

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

TanuHoque_0-1641406212665.png


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
New Contributor

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.