I have a column in a mysql table called "start_date" as a datetime. I'm returning the results from that table as XML. render :xml => @mystuff.to_xml However, instead of coming across like: 2006-05-28 00:00:00 It comes across in the XML instead as: 2006-05-28T02:00:00-04:00 Is there a way to make it match the mysql format, or another way to have it generate XML so the string matches the way mysql shows it? Otherwise, I can parse the way Rails is sending it back, just curious why the format is different. ??? --JesterXL
on 2006-05-29 04:38
on 2006-05-29 04:51
Hi ! 2006/5/28, JesterXL <firstname.lastname@example.org>: > 2006-05-28 00:00:00 > > It comes across in the XML instead as: > > 2006-05-28T02:00:00-04:00 This is the XML Schema date/time format: http://www.w3.org/TR/xmlschema-2/#dateTime Hope that helps !