Re: [Catalyst] Cat App on dotcloud

2011-11-02 Thread Dermot
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.  

[Catalyst] Dealing with timestamps from Postgres

2011-11-02 Thread Adam Jimerson
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

Re: [Catalyst] Dealing with timestamps from Postgres

2011-11-02 Thread Santiago Zarate
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

Re: [Catalyst] Dealing with timestamps from Postgres

2011-11-02 Thread Rippl, Steve
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