PostgreSQL 9.3 : Add/Remove QUARTER to/from timestamp

Question

我想在 PostgreSQL 9.3 版本中将 QUARTER 添加到 TIMESTAMP。

我的尝试:

用于添加:

SELECT TIMESTAMP '2016-01-01' + INTERVAL '01 QUARTER';

删除:

SELECT TIMESTAMP '2016-01-01' - INTERVAL '01 QUARTER';

********** Error **********  
ERROR: invalid input syntax for type interval: "01 QUARTER"  
SQL state: 22007  
Character: 42

Answer 1

那是因为 quarter 不属于 interval 输入的受支持单位。 The manual:

unit is microsecond, millisecond, second, minute, hour, day, week, month, year, decade, century, millennium, or abbreviations or plurals of these units;

改用'3 month'(或类似的):

SELECT timestamp '2016-01-01' + interval '3 month';