One way (if using DBIx::Class)
$dt_object = $c->model('DB::TableName')->find($row_index)->date_field
(or however your get your resultset)
$formatted_date_string = $dt_object->mdy('/');
where the mdy('/') can be whatever the DateTime object you're retrieving
supports (see CPAN docs).
Can obviously be combined into
$formatted_date_string =
$c->model('DB::TableName')->find($row_index)->date_field->mdy('/');
I just split it up to illustrate where the DateTime object is coming from.
On Wed, Nov 2, 2011 at 7:05 PM, Adam Jimerson <[email protected]> wrote:
> I'm hoping someone can help me with an issue that I am having with dates
> and timestamps that I am pulling out of my Postgres server.
> In my database my time stamps are stored like this 2011-05-07 13:53:41-04
> (timestamp with time zone), but in my Catalyst app the
> date looks like this 2011-05-07T13:53:41. The "T" instead of the space is
> driving me crazy, I think it is coming from DateTime::Format:Pg
> which Catalyst had me install when I first set up my application to use
> the database. Other than doing a find and replace then stash the
> results every time I want to pull back a date or timestamp is
> there something else that I can do?
>
> _______________________________________________
> List: [email protected]
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive:
> http://www.mail-archive.com/[email protected]/
> Dev site: http://dev.catalyst.perl.org/
>
>
--
Steve Rippl
Technology Director
Woodland Public Schools
360 841 2730
_______________________________________________
List: [email protected]
Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
Searchable archive: http://www.mail-archive.com/[email protected]/
Dev site: http://dev.catalyst.perl.org/
