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]

In reply to Re: MySQL Timestamp from CDBI to TT Date Plugin by cees
in thread MySQL Timestamp from CDBI to TT Date Plugin by dragonchild

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.