[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