Re: interval and timestamp change?

Chris Ruprecht <chrup999(at)yahoo(dot)com> writes:
> Here is Tom's explanation from that time:
> TIME is a reserved word now, or at least more reserved than it used to
> be. You'll need to write 'now'::time or CAST('now' AS time). Sorry
> about that, but SQL92 requires it...

Actually there's nothing wrong with his 'now', though as Brent points
out CURRENT_TIMESTAMP would be more standards-compliant. The real
problem is that INTERVAL is also a more-reserved word than it used to
be. So instead of

SELECT interval(('1/30/02 12:30 pm'::timestamp) - 'now');
ERROR: parser: parse error at or near "("

he needs

SELECT "interval"(('1/30/02 12:30 pm'::timestamp) - 'now');

or

SELECT (('1/30/02 12:30 pm'::timestamp) - 'now')::interval;

although since the difference of two timestamps is already an interval,
there's not really any need for the cast anyway. So this is sufficient:

SELECT '1/30/02 12:30 pm'::timestamp - current_timestamp;

regards, tom lane