Re: Weeks elapsed to Months elapsed conversion

From: Rodrigo E(dot) 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: 2008-05-30 17:19:55
Message-ID: a55915760805301019u76845baah307fd3f30711c2fc@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message yazicivo 2008-06-02 08:25:08 bcp.exe Fix Triggers
Previous Message Fernando Hevia 2008-05-30 16:22:08 Re: Weeks elapsed to Months elapsed conversion