Re: changing 'mons' in interval?

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Klint Gore <kg(at)kgb(dot)une(dot)edu(dot)au>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: changing 'mons' in interval?
Date: 2007-06-04 09:43:08
Message-ID: 20070604094308.GB16196@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Jun 04, 2007 at 06:51:37PM +1000, Klint Gore wrote:
> Is there a way to change mons in interval::text to the full word months
> without resorting to "replace(aninterval::text,'mon','Month')"? If it
> can handle locales as well that would be good (but I could live without
> it).

Have you considered using to_char to get the output in the exact format
you want?

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2007-06-04 09:46:28 Re: Tablespaces
Previous Message Lincoln Yeoh 2007-06-04 09:41:40 Re: Numeric performances