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@postgresql.org
-----------------------------------------
Get your free web based email at trade-india.com.
"India's Leading B2B eMarketplace.!"
http://www.trade-india.com/