arcgis rest api - How do I determine appropriate Date query syntax for a layer?

Sunday 2 July 2017

I'm writing a web mapping query tool to query Esri mapservice layers by date using the REST API.

It has been said that the syntax depends on what kind of database is behind the mapservice layer, as described in the help doc.

For oracle use this:

Datefield = date 'yyyy-mm-dd'

For SQL Server use this:

Datefield = 'yyyy-mm-dd hh:mm:ss'

How do I determine which database is being used by a particular mapservice layer so I can compose the query using the appropriate syntax?

Blog