PG-pg数据库DATE_TRUNC截取日期和获取最近六个月时间

SELECT CURRENT_DATE - (generate_series - 1) * INTERVAL '1 month' AS xdata FROM generate_series(1, 6)

点击查看代码

SELECT
	TO_CHAR( DATE_TRUNC( 'month', ( CURRENT_DATE - ( n - 1 ) * INTERVAL '1 month' ) ) :: DATE, 'MM' ) AS xdata 
FROM
	generate_series ( 1, 6 ) AS n ORDER BY xdata;