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