Date format issue after upgrading from 10.1 to 10.2

AlessioDi_Lorenzo

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

AlessioDi_Lorenzo

I got how to query:

no more:

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

but:

SAMPLING_DATE >= TIMESTAMP '01/01/2010' AND SAMPLING_DATE <= TIMESTAMP '10/10/2013'

This query works properly and I hope this helps, but I still have twoo questions:

1) I'm using date strings in DD/MM/YYYY format and I noticed this format works (the query return the correct results). How about changing the date format to MM/DD/YYYY? Is there a way to specify it in the TIMESTAMP function?

2) If I run a test query inside the ReST panel - without using the javascript web app that formats the results client side - the value of the SAMPLING_DATE field is in milliseconds. Can I apply the TIMESTAMP function in the outFields field to format the answer in something more human-readable?

Thanks