Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6290: converting interval from weeks to days - Mailing list pgsql-bugs

From John R Pierce
Subject Re: BUG #6290: converting interval from weeks to days
Date
Msg-id 4EBC7BDD.3080609@hogranch.com
Whole thread Raw
In response to BUG #6290: converting interval from weeks to days  ("Alexey Nalbat" <alexey_nalbat@hotbox.ru>)
Responses Re: BUG #6290: converting interval from weeks to days  (Craig Ringer <ringerc@ringerc.id.au>)
List pgsql-bugs
Tree view 
On 11/10/11 1:15 PM, Alexey Nalbat wrote:
> =>  select '1000000000 weeks'::interval;
>       interval
> ------------------
>   -1589934592 days

a billion weeks is like 19 million years.  somehow, I don't think that
postgresql's date math has quite that range.


--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast

pgsql-bugs by date:

Previous
From: "Alexey Nalbat"
Date:
Subject: BUG #6290: converting interval from weeks to days
Next
From: Robert Young
Date:
Subject: Re: Add statistics_collector_listen_addresses to fix hard-coding of "localhost"