nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

REST API Query by Date

JordanParfitt

I am trying to use the REST API to query by date. In the where field I want to enter something like this:

my_Date >= '06/15/2009 12:00:00 AM'

That is not working. I have tried many alternatives. Any help would be appreciated.

Sorry if this has been answered but I am having trouble searching the new forums.

Thanks,
Jay

Encontre mais publicações marcadas com

Accepted answers

JordanParfitt

A little more searching and....

"Accident_D" > date '2009-01-01 00:00:00'

That works...

Thanks All

All comments

JordanParfitt

A little more searching and....

"Accident_D" > date '2009-01-01 00:00:00'

That works...

Thanks All

RaviNarayanan

A little more searching and....

"Accident_D" > date '2009-01-01 00:00:00'

That works...

Thanks All

A bit more info regarding this. The syntax for date in the query should conform to the sytax that is supported by the underlying geodatabase. Please see section "Dates and time" in the following help topic.
http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00s500000033000000.htm

Thanks

KirkKuykendall

I don't see a property exposed by the REST API that indicates what type of query syntax I should use.

How do I determine what database is being used by a mapservice layer?

Without know that, it is difficult to compose the appropriate date query syntax.

Thanks!

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Links Rápidos

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.