I'm too lazy to go look for what a MySQL time stamp looks like so I can't directly address part one. Part 2 is probably best answered using DateTime or Date::Manip (there are many other data and time related modules on CPAN too).