Well, I would definitely store the UNIX datestamp in the database with the time() function as an unsigned integer or maybe a bigint.

But if you don't have Date::Manip as suggested above, the code scalar(localtime($time)) prints out a very nicely formatted date string in the same way that the UNIX date command does.

--
<code>perl -e "print qq/just another perl hacker who doesn't grok japh\n/"