nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

TIMESTAMP queries down to the second

WorthSparks

In my mobile app (in Swift), I query a feature service in ArcGIS Online. My where clause looks like this:

EditDate <SPAN class="operator token">></SPAN> <SPAN class="keyword token">TIMESTAMP</SPAN> <SPAN class="string token">'2018-11-17 23:29:34'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

My results include records with EditDate equal to the timestamp. I have printed the six returned features' EditDates to the console to make sure I wasn't missing something. They all printed this: "2018-11-17 23:29:34 +0000". Is this a bug in the query routines? Does the EditDate field hold the fraction of the second when the edit actually took place? If so, is there a way for me to access the fractional part in a query?

Trouver plus de publications taguées avec

Accepted answers

All comments

WorthSparks

I fixed my problem by adding one second to the time and using >=.

EditDate <SPAN class="operator token">>=</SPAN> <SPAN class="keyword token">TIMESTAMP</SPAN> <SPAN class="string token">'2018-11-17 23:29:35'</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

It seems like this should be more intuitive though.

RyanOlson1

The ArcGIS Runtime SDK for iOS supports down to millisecond. It seems that it's possible however the data was stored is where the date was truncated.

WorthSparks

In the ArcGIS Online feature service? Maybe this is a limitation of ArcGIS Online?

RyanOlson1

AFAIK the backend services support more precise dates. I'm wondering if it was just however the data was initially collected, the app that the data was initially collected in. I'm not sure how the data was entered, and with what interface. My guess is that is the source of the problem. You might want to ask on the forum associated with that app/interface.

WorthSparks

The data isn't collected. it is only when I query the feature service for EditDate, which is originated by the ArcGIS Online server, that I don't get sub-second accuracy.

RyanOlson1

Sorry. What application is populating the EditDate field?

WorthSparks

As far as I can tell, that gets populated during my call to AGSServiceFeatureTable.applyEdits(), either locally or on the server.

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.