Sql年份加减及年份列表，数字保留小数位数-postgre

年份加减

加天：select to_char(now()::timestamp + '1 day','YYYY-MM-DD') AS 后一天;

减天：select to_char(now()::timestamp + '-1 day','YYYY-MM-DD') AS 前一天;

加月：select to_char(now()::timestamp + '1 month','YYYY-MM') AS 后一月;

减月：select to_char(now()::timestamp + '-1 month','YYYY-MM') AS 前一月;

加年：select to_char(now()::timestamp + '1 year','YYYY') AS 后一年;

减年：select to_char(now()::timestamp + '-1 year','YYYY') AS 前一年;

年份列表

天列表：select to_char(generate_series('2000-01-01'::date , now() , '1 day') ,'YYYY-MM-DD');

date_trunc('DAY', slr.data_time) as dataTime

月列表：select to_char(generate_series('2000-01-01'::date , now() , '1 month') ,'YYYY-MM');

date_trunc('MONTH', slr.data_time) as dataTime

季列表：select distinct to_char(generate_series('2000-01-01'::date , now() , '1 month') ,'YYYY-Q');

to_char(date_trunc('QUARTER', slr.data_time),'YYYY-Q') as dataTime

年列表：select to_char(generate_series('2000-01-01'::date , now() , '1 year') ,'YYYY');

date_trunc('YEAR', slr.data_time) as dataTime

数字保留小数位数

0位：select cast(avg(值) as decimmal(10,0))

两位：select cast(avg(值) as decimmal(10,2))