Re: BUG #1757: timestamp 'epoch' is not absolute

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Steve Bennett" <S(dot)Bennett(at)lancaster(dot)ac(dot)uk>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1757: timestamp 'epoch' is not absolute
Date: 2005-07-07 15:12:46
Message-ID: 8281.1120749166@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Steve Bennett" <S(dot)Bennett(at)lancaster(dot)ac(dot)uk> writes:
> It appears that the timestamp 'epoch' is being interpreted as
> relative to the local timezone, rather than being an absolute time.

This is correct for timestamp ... you want timestamp with time zone.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-07-07 15:16:13 Re: BUG #1759: domain check constraint ignored in prepared statement
Previous Message Alvaro Herrera 2005-07-07 15:09:25 Re: BUG #1756: PQexec eats huge amounts of memory