[Dbix-class] Postgres timestamp with timezone problem

Alex Povolotsky tarkhil at over.ru
Tue Aug 8 13:13:52 GMT 2017


Hello

I have a table with timestamp with timezone columns; when I put, say, 
2017-08-08 12:25:00+0200, it is stored correctly (select in commandline 
client or plain DBD::Pg returns '2017-08-08 13:25:00+03', it's fine 
since I'm in Moscow (UTC+3).

However, DBIx::Class::InflateColumn::DateTime ignores timestamp.

get_column returns 2017-08-08 12:25:00 +0000, get_inflated_column 
returns object with floating timezone.

What can be wrong?

All timestamp fields are described as

   { data_type => "timestamp with time zone", is_nullable => 0 },

by dbicdump.

Alex




More information about the DBIx-Class mailing list