That's probably your database servers' time zone setting. If it's set to
UTC you'd probably get that. You might want to add an 'on_connect_do' to
your connection_info setting and execute the appropriate command to set
the timezone you need (e.g. 'SET TIME ZONE LOCAL' or 'SET TIME ZONE
Europe/Amsterdam' (for PostgreSQL this works, forgot what it is for MySQL)
Kiffin Gish wrote:
That worked, thanks. Only weird thing now is that the time is one hour
behind.
On Thu, 2010-02-11 at 12:45 -0300, Eden Cardim wrote:
"Kiffin" == Kiffin Gish <[email protected]> writes:
Kiffin> I've got a datetime column defined:
__PACKAGE__-> add_columns(
Kiffin> ... "last_modified", { data_type => "DATETIME",
Kiffin> default_value => undef, is_nullable => 1, size => undef, },
Kiffin> );
Kiffin> For some reason it's being displayed like this:
Kiffin> "2010-01-05T20:35:14"
Kiffin> How can I get that 'T' out of there, replacing it with the
Kiffin> usual space?
->last_modified->strftime('%F %T')
See perldoc DateTime for more formatting options.
--
Ben van Staveren
phone: +62 81 70777529
email: [email protected]
_______________________________________________
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/
