在PostgreSQL中可以直接对timestamp进行加减运算:
timestamp + interval
例子:
- SELECT now()::timestamp + '1 year';
- SELECT now()::timestamp + '1 month';
- SELECT now()::timestamp + '1 day';
- SELECT now()::timestamp + '1 hour';
- SELECT now()::timestamp + '1 min';
- SELECT now()::timestamp + '1 sec';
- select now()::timestamp + '1 year 1 month 1 day 1 hour 1 min 1 sec';
- SELECT now()::timestamp + (col || ' day')::interval FROM table
注意:
- 如果是跟表字段做加减,如最后一个例子,需要将拼接的字符串转换成interval 类型。