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:
thx
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
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!
awesome. i had no idea you could inject SQL in that way.
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:
So, I was looking for something different from a javascript workaround but at the moment - if I understood well - it is not possible.