BUG #6424: Possible error in time to seconds conversion - Mailing list pgsql-bugs

The following bug has been logged on the website:

Bug reference:      6424
Logged by:          Olaf
Email address:      o.bousche@krohne.com
PostgreSQL version: 9.1.2
Operating system:   Windows 7 - 64bits
Description:=20=20=20=20=20=20=20=20

Should the query

select
  extract(epoch
    from cast('2012-01-01 14:30:1' as
             timestamp) -
         cast('1970-01-01 0:0:0' as
              timestamp))) -=20
  extract(epoch
    from (cast('2012-01-01 14:30:1' as
              timestamp)))

return 0 instead of 3600?