On 1 November 2011 14:54, Lindolfo Lorn Rodrigues l...@lornlab.org wrote:
Hi Dermot, I got the same issue and open a ticket in dotcloud and they
answered:
Jérôme Petazzoni, Sep-05 21:46 (PDT):
Hi,
I remember that had a very similar issue when I tried to run Catalyst on
DotCloud.
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
If i'm not wrong, being basically a DateTime object you should be able
to do whatever you like with it instead of having to do a search
replace, consider using DBIx::Class::InflateColumn to have DBIx do the
job for you every time you need to use that specific model...
On Wed, Nov 2, 2011 at
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