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?

  • Although the Rest API theoretically abstracts away the data source, it would be nice to know if there some attribute or quirk that would indicate the data source for this kind of query. File this under the law of leaky abstractions joelonsoftware.com/articles/LeakyAbstractions.html – awesomo Nov 19 '12 at 20:52

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.