I did the same thing a month ago with Template::Toolkit so I have a format string handy. You'll need your item's creation time in epoch seconds to do this (swap it for "time()").

use Date::Format;
print time2str('%a, %d %b %Y %H:%m:%S GMT', time()), "\n";

[download]

Here's the TT2 version. This assumes a DB "item" which has an epoch seconds "created_time" that matches GMT. You can easily do hour offsets to the "gmt" with multiples of 60*60. 

[% USE date %]

<pubDate>[%- gmt = item.created_time -%]
[%- date.format(gmt, '%a, %d %b %Y %H:%m:%S GMT') -%]</pubDate>

[download]

Update: I left out the conversion I'm using from TIMESTAMP|DATETIME though there are more ways to do this. I *think* the regex will match different MySQL versions of the DB strings. Still have to do your own GMT adjustment somewhere if necessary. 

use Date::Calc;
my $item_time =
    Date::Calc::Mktime
    ( $mysql_timestamp =~
      /^(\d\d\d\d)\D*(\d\d)\D*(\d\d)\D*(\d\d)\D*(\d\d)\D*(\d\d)$/ );

print time2str('%a, %d %b %Y %H:%m:%S GMT', $item_time), "\n";

[download]

In reply to Re: XML::RSS timestamping items by Your Mother
in thread XML::RSS timestamping items by tomazos

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.