本文介绍了如何在PostgreSQL中直接对timestamp类型的数据进行加减运算，包括年、月、日、小时、分钟和秒等不同时间单位的增减操作。
转载地址:http://blog.youkuaiyun.com/dante_k7/article/details/5718712
在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
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
扫一扫
813
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
