You should look at inflating your timestamp values into objects using Class::DBI. You can use Time::Piece::mysql for this, or DateTime::Format::MySQL (there are others as well that will work like Class::Date which is described on the cdbi wiki).

use Time::Piece::mysql;
__PACKAGE__->has_a(date_col => 'Time::Piece');

# or

use DateTime::Format::MySQL;
__PACKAGE__->has_a(date_col => 'DateTime',
  inflate => sub { DateTime::Format::MySQL->parse_datetime(shift) },
  deflate => sub { DateTime::Format::MySQL->format_datetime(shift) });
[download]

Then when you have your Class::DBI object, and you retrieve the date column, you will get a Time::Piece or DateTime object that you can pass to the TT Date Plugin in whatever format it accepts.

Or, since your dates are now objects already, just use them directly in TT to format your dates. This removes the need for the Date plugin.

[% date_col.ymd('-') %]
[download]

Hi Dragonchild

Take a look at date_format if you want to use a sql type method to retrieve the datetime. The perl modules mentioned in earlier replies would be for a perl type solution. Personally I would go for the sql type method.

I find it laughable that this standard ISO8660 date format is not as widely supported as you'd expect of a standard date format.

You can use this via the Date plugin if you have Date::Manip installed;

[% manip = date.manip %]
[% manip.UnixDate("2012-12-21 06:32:12","%Y %b %d %H:%M") %]
[download]

$h=$ENV{HOME};my@q=split/\n\n/,`cat $h/.quotes`;$s="$h/."
."signature";$t=`cat $s`;print$t,"\n",$q[rand($#q)],"\n";
[download]

$stamp="YYYY-MM-DD HH:MI:SS";
($date,$time)=split(/\ /,$stamp);
($year,$month,$day)=split(/\-/,$date);
$newstamp=$time." $day/$month/$year";
[download]