Re: [BUGS] BUG #1117: Time calculation from epoch is 12 hours out

2004-03-26 Thread Stephan Szabo
On Fri, 26 Mar 2004, PostgreSQL Bugs List wrote: > The following bug has been logged online: > > Bug reference: 1117 > Logged by: Neil Cooper > > Email address: [EMAIL PROTECTED] > > PostgreSQL version: 7.3.4 > > Operating system: Red Hat ES 3.0 > > Description:Time c

Re: [BUGS] BUG #1117: Time calculation from epoch is 12 hours out

2004-03-26 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The output of the following query: > select '1970-1-1 00:00:00'::timestamp + '1080302400 seconds'::reltime; > gives: 2004-03-26 00:00:00. This is apparently exactly 12 hours wrong. I > believe the query should have given me: 2004-03-26 12:00:0

[BUGS] BUG #1117: Time calculation from epoch is 12 hours out

2004-03-26 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1117 Logged by: Neil Cooper Email address: [EMAIL PROTECTED] PostgreSQL version: 7.3.4 Operating system: Red Hat ES 3.0 Description:Time calculation from epoch is 12 hours out Details: I'm using the Postg