The following bug has been logged online:
Bug reference: 1757
Logged by: Steve Bennett
Email address: S(dot)Bennett(at)lancaster(dot)ac(dot)uk
PostgreSQL version: 8.0.3
Operating system: Linux
Description: timestamp 'epoch' is not absolute
I'm seeing a rather annoying problem converting timestamps between unix and
PostgreSQL. It appears that the timestamp 'epoch' is being interpreted as
relative to the local timezone, rather than being an absolute time.
e.g. I'm in the UK, and at the moment we're in summer time, which is UTC+1.
If I do:
select date_part('epoch', timestamp 'epoch');
Whereas if I do:
select date_part('epoch', timestamp 'epoch' AT TIME ZONE 'UTC');
Am I misunderstanding what's going on here?
Is there any circumstance where 'epoch' should vary according to the
timezone that you happen to be in?
Thanks in advance
pgsql-bugs by date
|Next:||From: Denis Vlasenko||Date: 2005-07-07 05:21:38|
|Subject: Re: BUG #1756: PQexec eats huge amounts of memory|
|Previous:||From: Tom Lane||Date: 2005-07-06 14:49:31|
|Subject: Re: Creating trigger function with argument(s) gets backend crash. |