date problems inserting amazonpayments orders into database

[AmazonPayments]

"2009-11-26T12:48:18.000Z" is not in "YYYY-MM-DD HH:MM:SS" format which MySQL uses. If you're sending the date as 2009-11-26T12:48:18.000Z then I'm not surprised that it's converting it to something else.

I parse the date and send it in a mysql supported format as you suggested. it works after sending it in that way.

my concern is the time. I send the date time as 2009-11-26 12:48:18 which is from the order report. That time is a PDT one. what if a merchant hosted his store in which PDT is default?

In that case, i have to convert them to the desired timezone where the store is located. any idea on how to do it?

- Bala