The following bug has been logged online:
Bug reference: 6290
Logged by: Alexey Nalbat
Email address: alexey_nal...@hotbox.ru
PostgreSQL version: 9.1.1
Operating system: Ubuntu
Description:converting interval from weeks to days
Details:
= select '10
On 11/10/11 1:15 PM, Alexey Nalbat wrote:
= select '10 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
On 11/11/2011 09:35 AM, John R Pierce wrote:
On 11/10/11 1:15 PM, Alexey Nalbat wrote:
= select '10 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.
It