in reply to formatting mysql timestamp
You may like some of the date-related modules mentioned on The Perl Advent Calendar. See the articles on Date::Parse and DateTime.
However, my absolute favorite modules for this is Date::Manip. It does an amazing job of recognizing almost any date format. Here's some working code for your example:
$ perl -MDate::Manip -e'print UnixDate("20050519112656","%m-%d-%Y %I:% +M %p %Z\n")' 05-19-2005 11:26 AM EDT
Notice that I didn't have to say what format the input was in!
|
|---|