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