Date Timezone Issue?

Permanently deleted user

24. August 2018 19:54

I have a column in the geodatabase that is:

 

GPSFixTime = 2018-08-24 15:40:12.0000000

 

Yet in the GeoCortex viewer the time is displayed:

 

GPSFixTime

 

Aug 24, 2018 7:40 PM

 

Any ideas on what to check would be appreciated.

0

• 

  Permanently deleted user

  26. August 2018 18:12

  My client noticed the same thing. I isolated it to "Server Time" vs "Client Local Time".  However our Serer time is still the same time zone as the client machine.  It's always 6 hours different like yours.

   

  Sorry I don't have a solution yet but wanted to add myself to this thread so we can resolve together.

  0
• 

  Permanently deleted user

  27. August 2018 13:52

  It may not help, but try this:

   

  In Essentials Manager, open your site, click on the "Site Info" tab on the left.  Set the appropriate Data Time Zone and Display Time Zone from their respective dropdown lists.  Click "Apply Changes" and "Save Site".  Reload your viewer and see if that fixed the issue.

  0
• 

  Permanently deleted user

  27. August 2018 20:31

  The fix was to:

   

  - enter Geocortex Essentials Manager

   

  - On the Map, Edit the Layer

   

  - Click the Fields tab

   

  - Change the "Data Time Zone" to UTC

   

  - Apply and Save Site

   

  Why this worked: the Data Time Zone field is asking what timezone the ArcGIS Rest Service will return. To find this out I went to the Feature Service rest enpoint and executed the query using the url at the bottom of the screen. I then took my field (GPSFixTime) result and converted it online using an Epoch time converter ( https://www.epochconverter.com/). This showed me the time was UTC.

   

  Several things were confusing to me:

   

  - The GeoEvent data logger tool converts the received data using the ArcGIS Service setting under the Service Parameters. So I was unaware a conversion was happening.

   

  - Sql Server Management Studio also presents the column in the timezone of my PC.

   

  So I misled myself into thinking the time being sent was in Eastern time when it was UTC all along.

   

  Hopefully this helps someone else. This could be made more obvious with a little development effort to dislay an example data or some language explaining the field better and how to figure out how to set it correctly. Or maybe this posting is all that is needed. Or maybe I'm the only one who couldn't figure it out easily. *smile*

  0

Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.