Re: to_char(interval) --- done?

Larry,

> I had a need that should(!) be in the archives.  Just to reiterate my need:
>
> I input a contract length, in months, and wanted to get it back out as
> months.  There is no current way to do this, so I store it as an INT and
> concatenate the word months to do the
> date arithmetic.

What about EXTRACT(months FROM <interval_field>)?

This annoyingly wraps around if it's more than 12 months, but that was part of
my proposal ...

--
Josh Berkus
Aglio Database Solutions
San Francisco