topic Did the date format change for Query, REST, Post, JSON responses at ags 10? in ArcGIS JavaScript Maps SDK Questions

Did the date format change for Query, REST, Post, JSON responses at ags 10?

KevinGooss — Tue, 04 Jan 2011 15:47:15 GMT

On my 9.3.1 server i get this response:

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

But on my 10 server i get this:

"ORIG_HRZ_COLL_DATE" : 1294185600000

Am I in error here or was there some fundamental change made in this area going from ags 9.3.1 to ags 10 or is it in the js api?
If yes, then is there a list of all changes like this somewhere? It's very frustrating to have to find them like easter eggs.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

NianweiLiu — Tue, 04 Jan 2011 17:40:45 GMT

I've noticed it too. It is now presented as epoch millisec since 01/01/1970 GMT, and you have to handle timezone too.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

KevinGooss — Tue, 04 Jan 2011 17:41:58 GMT

this is disappointing. and to find out this way doesn't make it any easier to swallow.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

KevinGooss — Tue, 04 Jan 2011 17:53:33 GMT

The result set at 10 now also includes the data type of each return field in the alias collection that precedes the results. So now you cannot just ignore the data type and return it to the users eyes or else they will see that ugly date value.
Now I'm wondering if there are other types that have been modified.
Not pretty.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

KevinGooss — Thu, 13 Jan 2011 15:06:59 GMT

I'm also having issues now with inserting dates into features that I add to ags via my SOE.
If i insert a new record and set the date field to 01/09/2011 and then i turn around and query that feature i get the epoch format back which i convert to .... 01/08/2011.
Is there a time zone issue going on or something?
Perhaps someone who was involved with the changes in the date handling could throw together some notes or, say, documentation about what was done and how to deal with the new way of doing things?

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

KellyHutchins — Fri, 14 Jan 2011 14:08:17 GMT

Here are a few links that might help.

This info is from the rest doc:
http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/mapserver.html#response
Support for time-aware map services was added at 10. If the map supports quering and exporting maps based on time, the response will include a timeInfo property which includes information such as the map's time extent and the map's native time reference. However, note that the REST API always encodes time in UTC (milliseconds from epoch).

We also have some information on working with time in the JS API 'Working with time-aware layers' help doc:
http://help.arcgis.com/EN/webapi/javascript/arcgis/help/jshelp_start.htm#jshelp/inside_temporal.htm

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

PeterTimmers — Tue, 24 May 2011 01:20:28 GMT

If I had a date field with local time zone datetimes how would I get it to stop showing times 10 hours ahead?

ie. point collected 10am local time gets shown as 8pm.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

DanMcCoy — Fri, 04 Nov 2011 22:49:26 GMT

Kelly,

Is this considered a new feature rather than a bug, then? There really should be some better documentation explaining why the REST date format has changed between 9.3.1 & 10... and how to handle it in the Web APIs...

Thanks,

Dan

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

NickHetrick — Tue, 06 Dec 2011 21:07:19 GMT

The links provided don't help has anyone figured this out. I really don't want to recode my flex app to support this.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

NickHetrick — Tue, 06 Dec 2011 21:32:13 GMT

Luckily the AMF format does not change the date values. Switching to using amf instead of json worked for me in my flex app. Not a solution for others using JS and Silverlight though.

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

StephanieWidas — Tue, 07 Feb 2012 13:27:55 GMT

We just upgraded our ArcGIS Server from 9.3 to 10. We're now having that date issue described above. How is everyone handling this? How do I fix my Flex widgets and JavaScript apps to display the date/time fields the way we're used to seeing them (mm/dd/yyy hh:mm:ss)?
Thanks,
Stephanie

Re: Did the date format change for Query, REST, Post, JSON responses at ags 10?

KevinGooss — Tue, 07 Feb 2012 18:54:23 GMT

I feel your pain. This was a large hassle. Don't know about flex but this was helpful for me in js:

    Date.prototype.toFormattedDateString = function () {
        return isNaN(this) ? 'NaN' :

            [
                _addLeadingZero(this.getUTCMonth() + 1),
                _addLeadingZero(this.getUTCDate()),
                this.getUTCFullYear()
            ].join('/');
    };

    Date.prototype.toFormattedDateTimeString = function () {
        return isNaN(this) ? 'NaN' :

            [
                _addLeadingZero(this.getUTCMonth() + 1),
                _addLeadingZero(this.getUTCDate()),
                this.getUTCFullYear()
            ].join('/') + " " + _addLeadingZero(this.getUTCHours()) + ":" + _addLeadingZero(this.getUTCMinutes()) + ":" + _addLeadingZero(this.getUTCSeconds());
    };