Jim Ballard writes:
> I'd like to get the difference between two timestamp columns expressed
> as an interval with units "year to month." I believe the standard way
> to express this is as:
>
> (timestamp1 - timestamp2) year to month
timestamp1 - timestamp2
The units of the interval are calculated automatically.
> But this gives me a syntax error at "year". I also can't find a way
> to cast this to the desired interval units.
extract, date_part, date_trunc are available.
--
Peter Eisentraut peter_e(at)gmx(dot)net http://funkturm.homeip.net/~peter