Postgres timestamp with timezone problem

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Postgres timestamp with timezone problem

Alex Povolotsky
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@...
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Postgres timestamp with timezone problem

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 <[hidden email]> 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@...


_______________________________________________
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@...
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate

Re: Postgres timestamp with timezone problem

Alex Povolotsky
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 <[hidden email]> 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@...
>
> _______________________________________________
> 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@...
>


_______________________________________________
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@...
Loading...