Find vs Advanced Query - Epoch Time Conversion
I'm using a map service that contains a esriFieldTypeDate field which reflects an accident date. Now, when I use the Find > Rectangle on a single map point, picture #1 reflects what I get:
/customer/servlet/servlet.FileDownload?file=00P6000000eltiAEAQ
Notice the accident date which is 03/01/2014 . That's fine, since this matches what was in the .mxd for that particular OBJECTID.
When I use the advanced query and query the police incident number ie. 'SU14008705', which is also an unique number, picture #2 reflects what I receive in my results window:
/customer/servlet/servlet.FileDownload?file=00P6000000em1MCEAY
Same record, but now it shows me an accident date of 02/28/2014....!! When I query the REST end point and retrieve the record via the OBJECTID, I use the resultant Unix Epoch time format and paste it into an Epoch time converter and picture #3 shows the results I get:
/customer/servlet/servlet.FileDownload?file=00P6000000elzk5EAA
So the find > rectangle results have given me GMT: Sat, 1 Mar 2014 00:00:00 UTC but the advanced query has given me "Your Time Zone: Friday, February 28, 2014 7:00:00 PM GMT-5
Can someone kindly explain why the same record can yield two different date results?
Walter
-
After further review, while still using the original date/time example I used in my original posting, Essentials is using the Greenwich Mean Time GMT ... Sat. 1 Mar 2014 00:00:00 UTC, rather than Your Time Zone : Friday, February 28, 2014 7:00 PM GMT-5.
Originally, the date I have in my .mxd file is 02/28/2014 (type date) and after the map is published, it's converted to esriFieldTypeDate and applies a time (somehow) and converts it to Unix Epoch Time.
I've logged a forum inquiry on Esri's Arcgis Server forum, but still no response.
Does anyone know why Essentials uses the GMT only? Or has there been any other concern/requirement to set "My Time Zone" while using dates?
Walter
0
Please sign in to leave a comment.
Comments
1 comment