[Catalyst] Dealing with timestamps from Postgres

Adam Jimerson vendion at gmail.com
Thu Nov 3 02:05:24 GMT 2011


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?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.scsys.co.uk/pipermail/catalyst/attachments/20111102/d71c6=
dcc/attachment.htm


More information about the Catalyst mailing list