[Catalyst] Dealing with timestamps from Postgres

Santiago Zarate santiago at zarate.net.ve
Thu Nov 3 02:31:56 GMT 2011


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 9:05 PM, Adam Jimerson <vendion at gmail.com> 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: Catalyst at lists.scsys.co.uk
> Listinfo: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/catalyst
> Searchable archive: http://www.mail-archive.com/catalyst@lists.scsys.co.uk/
> Dev site: http://dev.catalyst.perl.org/
>
>



More information about the Catalyst mailing list