Re: Age function

From: <mallah(at)trade-india(dot)com>
To: <nolan(at)celery(dot)tssi(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Age function
Date: 2003-04-08 02:36:38
Message-ID: 1109.219.65.232.28.1049769398.squirrel@mail.trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I dont think so even we had faced the same problem
may be replace(age(xyz) , 'mons' , 'months' ) is ur best
bet

regds
mallah

> Is there any way to change the output of the age function so that it uses 'months' instead of
> 'mons', ie, so that the output is:
> 7 years 4 months 3 days
> instead of
> 7 years 4 mons 3 days
> --
> Mike Nolan
>
>
> ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and
> unsubscribe commands go to majordomo(at)postgresql(dot)org

-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lamar Owen 2003-04-08 02:51:48 Re: Failed dependencies: perl(Pg) is needed by postgresql-contrib
Previous Message Medi Montaseri 2003-04-08 02:15:09 Re: Arrays ... need clarification....