BUG #5966: extract(epoch..) function error

From: "Ricardo Solanilla" <info(at)abaco-tandil(dot)com(dot)ar>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5966: extract(epoch..) function error
Date: 2011-04-06 23:17:42
Message-ID: 201104062317.p36NHgAR084504@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-bugs

The following bug has been logged online:

Bug reference: 5966
Logged by: Ricardo Solanilla
Email address: info(at)abaco-tandil(dot)com(dot)ar
PostgreSQL version: 8.3.0 b.1400
Operating system: windows nt
Description: extract(epoch..) function error

-- try this

select (extract(epoch from (date('2011-03-20'))) - extract(epoch from
(date('2011-03-19')))) / 3600

-- it must be 24 (hours), only occurs in march 19,2011
-- in v. 8.0 work fine!!


Browse pgsql-bugs by date

  From Date Subject
Next Message Brendan Jurd 2011-04-07 06:07:32 Failed assert ((data - start) == data_size) in heaptuple.c
Previous Message Alvaro Herrera 2011-04-06 16:14:01 Re: BUG #5965: PostgreSQL crashes during connection