Date Conversion

Can someone help me format the following date into a db-friendly datetime value?

Here is the date I get from an XML file... xmldate = "2010-03-31T07:47:46 -500"

But xmldate.to_datetime isn't handling the timezone... 2010-03-31T07:47:46+00:00

Any ideas how I get to this?... 2010-03-31T07:47:46-05:00

Hi,

Please, try it:

DateTime.parse("2010-03-31T07:47:46 -500").to_s