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 ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]