It was purely my error. Having 5 different times of arrival and departure, I've wrote with correct timezone one and tried to get annother....

14.08.2017 2:39, John Stoffel пишет:
Can you reproduce this in a smaller test case you can post by any chance?  And 
which version of the code are you running and which version of Postgres?  And 
do you have your TIMEZONE env var set as well by any chance?  More details 
please!

Sent from my iPhone

On Aug 8, 2017, at 9:13 AM, Alex Povolotsky <tark...@over.ru> wrote:

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


_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk



_______________________________________________
List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
IRC: irc.perl.org#dbix-class
SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
Searchable Archive: http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk

Reply via email to