--生成月份字典表
drop table if exists monthmapping;
create table monthmapping as
select cast(to_char(onday,'yyyy-mm')||'-01' as char(10)) monthid,onday from (
select cast('2001-01-01 00:00:00' as timestamp) + (c ||' day')::interval as onday from generate_series(0,10000) as tab(c))tb
where onday<='2028-12-31'
distributed by(monthid,onday);
--当前时间加1年
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';
--当前时间加1年1月1天1时1分1秒
select now()::timestamp + '1 year 1 month 1 day 1 hour 1 min 1 sec';
--把columnname字段转换成天然后相加
SELECT now()::timestamp + (columnname || ' day')::interval FROM tablename
