Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
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 – awesomo Nov 19 '12 at 20:52

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.