Re: BUG #14182: Wrong time stamp exactly at 1996 hour 3

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Olmo Zavala Romero <olmozavala(at)gmail(dot)com>
Cc: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14182: Wrong time stamp exactly at 1996 hour 3
Date: 2016-06-08 21:50:23
Message-ID: d3baf40e-4da8-3aec-bd2e-feddc686e017@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 6/8/2016 2:48 PM, Olmo Zavala Romero wrote:
> Is there a function that do not take into account the time zone?
> I have defined my variable as "timestamp WITHOUT TIME ZONE" and my
> original data do NOT have DST so how can I add this into my database.

set your client timezone to UTC

--
john r pierce, recycling bits in santa cruz

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2016-06-08 22:07:42 Re: Fwd: BUG #14181: pg_upgrade: operator family "btree_hstore_ops" does not exist
Previous Message John R Pierce 2016-06-08 21:39:52 Re: BUG #14182: Wrong time stamp exactly at 1996 hour 3