> > 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.
Sorry, but that's dumb (IMHO). The unix epoch is not relative to the
I'm now using a function to convert from unix times to timestamps, since
the alternative is ugly and verbose even by SQL standards...
create function epoch(integer)
returns timestamp with time zone
as 'select timestamp with time zone \'epoch\'
+ interval \'1 second\' * $1;'
language sql immutable;
Is there a better way?
pgsql-bugs by date
|Next:||From: Tom Lane||Date: 2005-07-07 20:52:19|
|Subject: Re: BUG #1757: timestamp 'epoch' is not absolute |
|Previous:||From: Jim C. Nasby||Date: 2005-07-07 20:29:07|
|Subject: FreeBSD 4.x pthreads issues|