Weeks elapsed to Months elapsed conversion

From: Allan Kamau <allank(at)sanbi(dot)ac(dot)za>
To: pgsql-sql(at)postgresql(dot)org
Subject: Weeks elapsed to Months elapsed conversion
Date: 2008-05-30 09:21:41
Message-ID: 483FC725.5030800@sanbi.ac.za
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,
I have a simple question (tried googling but found no answers). How do I
convert weeks elapsed into months elapsed?
I have data that contains duration in weeks (without any other date
values such as year and so on) for example a week value of 14 and I
would like to convert the 14 weeks to 3 months (some lose of accuracy
expected).
Expected tests may be:
14 weeks yields 3 months.
1 weeks yields 0 months.

Is there such a function. The rudimentary solution (may reduce lose of
accuracy) am thinking of is to add the weeks to the value returned by
clock_timestamp() then subtract clock_timestamp() from it. The question
now is how to convert the returned value to months elapsed as opposed to
days elapsed.

Allan.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bart Degryse 2008-05-30 14:56:28 Re: Weeks elapsed to Months elapsed conversion
Previous Message Scott Marlowe 2008-05-30 04:41:02 Re: String comparison problem.