查询昨日，今日，最近三十天，上月，本月，sql语句

查询昨日，今日，最近三十天，上月，本月，sql语句

--自定义时间
SELECT
	to_char( tt.DAY, 'yyyy-mm-dd' ) AS orderDate 
FROM
	(
	SELECT
		generate_series (
			CAST ( to_char( to_date( '2021-03-10', 'YYYY-MM-dd' ), 'yyyy-mm-dd' ) AS DATE ),
			CAST ( CAST ( to_char( to_date( '2021-03-31', 'YYYY-MM-dd' ), 'yyyy-mm-dd' ) AS TIMESTAMP ) AS DATE ),
			'1 d' 
		) AS DAY 
	) AS tt 
ORDER BY
	orderDate;

查询最近三十天sql语句

--最近30天
WITH RECURSIVE ts ( v ) AS (
	 VALUES ( CURRENT_DATE ) 
	 UNION ALL SELECT v + 1 FROM ts WHERE v < CURRENT_DATE + 30
	 ) 
SELECT *  FROM ts;