topic Re: date output format in ArcGIS JavaScript Maps SDK Questions

date output format

AlessioDi_Lorenzo — Thu, 01 Jul 2010 09:05:10 GMT

Hi all,

when I execute a query against a mapservice i get dates in this format:

Mon Jun 28 00:00:00 CEST 2010

using jquery I'm able to format it as dd/mm/yyyy

My question is:
is there a way to translate the date directly into the query?
Something like:

// Query
myQuery = new esri.arcgis.gmaps.Query();
myQuery.outFields = ["ID","NAME","TO_CHAR(DATE, dd/mm/yyyy)"];
myQuery.where = "1=1";

thx

Re: date output format

AdamPfister — Thu, 01 Jul 2010 11:52:17 GMT

what you've shown there is not possible i don't think. if you want it coming in directly as a formatted date i think your only option is to create a new field and calculate it from the DateTime field as text in whatever format you need. then you can specify that new field in your outFields list.

Re: date output format

AlessioDi_Lorenzo — Thu, 01 Jul 2010 13:27:40 GMT

what you've shown there is not possible i don't think. if you want it coming in directly as a formatted date i think your only option is to create a new field and calculate it from the DateTime field as text in whatever format you need. then you can specify that new field in your outFields list.

mmm... yes, it works but it is still a workaround (even if better than the javascript one...) and I was looking for a native solution 🙂

Thanks anyway

OT
In my opinion esri's js apis is a good tool but it has to be improved from the point of view of the query management. At least ORDER BY and GROUP BY clause and the DISTINCT selection have to be supported!

Re: date output format

AdamPfister — Thu, 01 Jul 2010 16:15:04 GMT

mmm... yes, it works but it is still a workaround (even if better than the javascript one...

awesome. i had no idea you could inject SQL in that way.

Re: date output format

derekswingley1 — Thu, 01 Jul 2010 17:03:28 GMT

You can, but it's kind of hacky and dependent on what is supported by the underlying data source. I would still format the date with JavaScript.

Re: date output format

hayaticm — Tue, 06 Jul 2010 05:29:16 GMT

have you found the solution?
mine is coded this way:

layerDefs[0] = "ZON='DATE = TO_DATE('"+ (dojo.byId('DATE').value) +"','YYYY-MM-DD')";

Re: date output format

AlessioDi_Lorenzo — Tue, 06 Jul 2010 06:06:06 GMT

have you found the solution?
mine is coded this way:

layerDefs[0] = "ZON='DATE = TO_DATE('"+ (dojo.byId('DATE').value) +"','YYYY-MM-DD')";

thank you, but using the google extensions apis I prefer jquery to dojo.
Formatting date with javascript is quite simple in jquery also:

$.format.date(attribute["FIELD_NAME"],'dd/MM/yyyy')

So, I was looking for something different from a javascript workaround but at the moment - if I understood well - it is not possible.