1. I have a report which will give me the time field as `$time='Wed, 25 Aug 2010 13:43:38 +0000'.` I am currently storing this into my MySql DB exactly like this and generating a custom report with the same time. I am in EST time so i want to know how i can change the $time field to show it according to `'Wed, 25 Aug 2010 09:43:38 '`. i want to remove that +0000 and change the timings to EST. I want to store it into the DB in this format, which i saved as a varchar.
2. I also want to be able to split this $time and save it as `$timeday='Wed, 25 Aug 2010'` and `$timetime='09:43:38'`. splitting it by counting the no of characters might work but problem would arise when it is like `Wed, 9 Aug 2010` or if i get the report time as `Wed, 1 Sept 2010`, which i am not sure whether the month would always be 3 characters or can change.

Thank you :)