AnsweredAssumed Answered

Feature Layer - Date Query

Question asked by jonathandicken on Oct 14, 2014
Latest reply on Oct 22, 2014 by JNery-esristaff

Hi,

 

I was hoping you could clarify the correct syntax for performing a date query on an attribute in the runtime.

 

Our queries were working in 10.2.3, but now return the exception 'SQL error or missing database : ', though the only change we have made is to use the new runtime.

 

We are performing our queries using the QueryAsync method, with a SpatialQueryFilter which includes a geometry to query the layer with as well as a where clause containing ATTRIBUTE_NAME > date '2000-08-13 12:00:00' for example. I have attached the full stack trace.

 

Interestingly if I don't add the geometry to the query then I don't see the exception, but I also don't get the expected features returned.

Outcomes