+ Reply to Thread
Results 1 to 4 of 4

Thread: REST API Query by Date

  1. #1
    Jordan Parfitt
    Join Date
    May 2010
    Posts
    42
    Points
    3
    Answers Provided
    2


    0

    Default REST API Query by Date

    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

  2. #2
    Jordan Parfitt
    Join Date
    May 2010
    Posts
    42
    Points
    3
    Answers Provided
    2


    0

    Default Re: REST API Query by Date

    A little more searching and....

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

    That works...

    Thanks All

  3. #3
    Ravi Narayanan

    Join Date
    Oct 2009
    Posts
    230
    Points
    30
    Answers Provided
    5


    0

    Default Re: REST API Query by Date

    Quote Originally Posted by jparfitt View Post
    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/arcgisdesk...0033000000.htm

    Thanks

  4. #4
    Kirk Kuykendall

    Join Date
    Oct 2009
    Posts
    295
    Points
    3
    Answers Provided
    0


    0

    Default Re: REST API Query by Date

    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!
    Kirk Kuykendall
    AmberGIS Programming Services
    Now answering questions at http://gis.stackexchange.com

+ Reply to Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts