Hello,
I have a remote Coldfusion CFC returning a query of sales orders.
In this query there is a field containing the date/time of the order (encoded
in a DATETIME
field in a mySQL table).
When called, this CFC returns a wddx (xml) packet with the data (query).
In this packet the date/time is encoded in the following format :
2005-4-11T16:55:42+1:0
When I bind this query to a datagrid in a Flex application, the date/time is
shown as :
Monday Apr 11 16:55:42 GMT+0200 2005
When I trace in the Network monitor, I see that the returned xml packet
contains :
xsd:dateTime 2005-04-11T14:55:42.000z
The SOAP response is the same
and the WebService onResult is :
Mon Apr 11 16:55:42 2005 (+-2:00)
wich is what is (nearly) shown in the datagrid.
What must I do to have the date/time format in the datagrid shown as, for
example,
2005-04-11 16:55:42
so i can correctly sort the grid. For the moment, as the day of the week begin
the format,
this column sorts by day of week first.
Do I have to use DateFormatter, and if yes, with wich exact syntax ?
Many thanks.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/flexcoders/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
