date output format

Question

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

AlessioDi_Lorenzo · Answer

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.

hayaticm · Answer

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

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

derekswingley1 · Answer

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.