Query FeatureLayer by date

Question

Can someone give me an example of how I would query a featurelayer by date?

I have a field in my featureservice named 'time'. The field type is: type: esriFieldTypeDate

Is this documented anywhere what that field type expects? I've sent all kinds of different date formats including:

mm/dd/yyyy
yyyy-mm-dd
yyyy-mm-dd HH:MM:SS
unix_time_stamp (1399336752182)

I'm sure someone out there has queried features before or after a particular date... I'd just like to see an example as I can't find any API docs that show how this should be done.

JimWharton · Answer

The service has been regenerated, nothing exists there yet. The ESRI Date Type is the only date/time type that I can see.

Now, from all the responses here, a normal unix timestamp is what ArcGIS Online services expect as a param.

(The number of seconds from Jan 1, 1970) Is this correct?

JohnGrayson · Answer

Jim,

are you sure that's the correct url?  The service seems to be empty.  When using 'where: 1=1' and 'returnCountOnly: true' parameters:

Request:
https://services1.arcgis.com/BqQ60RORKMjmx3jf/ArcGIS/rest/services/Photos_Template/FeatureServer/0/query?where=1%3D1&returnCountOnly=true&f=json

Result: { "count": 0}

Jayanta_Poddar_3-1618139177036.png

JimWharton · Answer

I guess I must be using the wrong type of date field or something. That doesn't work for me.

Here's my service definition: https://services1.arcgis.com/BqQ60RORKMjmx3jf/ArcGIS/rest/services/Photos_Template/FeatureServer/0 (I don't think  token is required)

-Jim