Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

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 joelonsoftware.com/articles/LeakyAbstractions.html –  awesomo Nov 19 '12 at 20:52

Your Answer

 
discard

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

Browse other questions tagged or ask your own question.