topic Re: QueryTask for ORACLE Date Field in ArcGIS API for Silverlight Questions

QueryTask for ORACLE Date Field

BradBarnell — Sun, 27 Mar 2011 22:00:19 GMT

Is there some trick to getting the QueryTask to work on an ORACLE date field in the Silverlight API? Here's what I have tried so far in the Where string:

MyFieldName = TO_DATE('2010-04-19 00:00:00','YYYY-MM-DD HH24:MI:SS')

MyFieldName = TO_DATE('2010-04-19','YYYY-MM-DD')

MyFieldName = TO_DATE('12/19/2010','MM,DD,YYYY')

The error message I get from the API is "Unable to complete Query operation"

Re: QueryTask for ORACLE Date Field

JenniferNery — Mon, 28 Mar 2011 17:05:12 GMT

I think this might be a related thread: http://forums.arcgis.com/threads/14935-Query-on-Date-data-types.

Are you able to perform this query using the REST endpoint from your web browser? Can you compare this web request on Fiddler with the request made from using Silverlight app?

Re: QueryTask for ORACLE Date Field

JMcNeil — Mon, 28 Mar 2011 20:20:55 GMT

You will probably have to format the date...like your first attempt but try to add

MYDATEFIELD = To_Date('2011-03-28 00:00:00 AM','MM/DD/YYYY HH:MI:SS AM')

j

Re: QueryTask for ORACLE Date Field

BradBarnell — Tue, 29 Mar 2011 01:42:45 GMT

Thanks for replys. I tried various formats in the REST endpoint with no luck, but will continue with others.