Having trouble with Interval computation
Jim Ballard <jballard@netezza.com>
From: "Jim Ballard" <jballard@netezza.com>
To: <pgsql-general@postgresql.org>
Date: 2001-07-16T15:44:03Z
Lists: pgsql-general
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 But this gives me a syntax error at "year". I also can't find a way to cast this to the desired interval units. What is the proper way to express this in Postgres? Will the standard form be supported at some point? Thanks very much, Jim Ballard jballard@netezza.com