digy79

Date format issue after upgrading from 10.1 to 10.2

Discussion created by digy79 on Oct 10, 2013
Latest reply on Oct 14, 2013 by ahoque-esristaff
Hi all,

I just upgraded ArcGIS for Server 10.1 to ArcGIS for Server 10.2.
Before the upgrade, date fields in my MapServices response were like this:

"SAMPLING_DATE" : "1/5/2011 12:00:00 AM"


now, with 10.2, they are:

"SAMPLING_DATE" : 1294185600000


All of my web applications, to filter the feature displayed on maps, performs queries sending parameters about dates, like this:

SAMPLING_DATE >= TO_DATE('01/01/2010','DD/MM/YYYY') AND SAMPLING_DATE <= TO_DATE('10/10/2013','DD/MM/YYYY')


Now similar queries do not work and the rest endpoint returns "Unable to complete operation".

How can I query date fields now in 10.2 and (better) how can I have date fields again as they were in 10.1?

Thanks in advance

Outcomes