On Apr 6, 2011, at 12:18, Christine Penner wrote:
> This still gave me a sytax error. The other suggestion to multiply the interval field by 1 year also gave me a syntax error.
What was the error? And it's preferable to do multiply rather than do the equivalent of an eval on some string.
select (current_timestamp at time zone 'utc' + CAST(3 AS SMALLINT) * interval '1 year');
?column?
----------------------------
2014-04-06 16:27:30.273562
(1 row)
Michael Glaesemann
grzm seespotcode net