Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Weeks elapsed to Months elapsed conversion
- From: "Rodrigo E. De León Plicet" <rdeleonp(at)gmail(dot)com>
- To: "Allan Kamau" <allank(at)sanbi(dot)ac(dot)za>
- Cc: pgsql-sql(at)postgresql(dot)org
- Subject: Re: Weeks elapsed to Months elapsed conversion
- Date: Fri, 30 May 2008 12:19:55 -0500
- Message-id: <a55915760805301019u76845baah307fd3f30711c2fc(at)mail(dot)gmail(dot)com>
On Fri, May 30, 2008 at 4:21 AM, Allan Kamau <allank(at)sanbi(dot)ac(dot)za> wrote:
> Expected tests may be:
> 14 weeks yields 3 months.
> 1 weeks yields 0 months.
Assuming 4 week months:
SELECT 14 / 4 AS "3 months", 1 / 4 AS "0 months"
3 months | 0 months
----------+----------
3 | 0
(1 row)
- References:
- Weeks elapsed to Months elapsed conversion
- From: Allan Kamau
- Weeks elapsed to Months elapsed conversion
- Prev by Date: Re: Weeks elapsed to Months elapsed conversion
- Previous by thread: Re: Weeks elapsed to Months elapsed conversion
- Indexes: