Mysql模拟sqlserver的master..spt_values 获取查询两个日期之间的日期列表yyyy-mm-dd

Mysql 获取查询两个日期之间的日期列表yyyy-mm-dd

效果

1.创建表

CREATE TABLE num_temp_0225 ( i INT );

2.插入数据

INSERT INTO num_temp_0225 ( i )
VALUES
	( 0 ),
	( 1 ),
	( 2 ),
	( 3 ),
	( 4 ),
	( 5 ),
	( 6 ),
	( 7 ),
	( 8 ),
	( 9 );

3.查询

SELECT
	adddate( '2012-09-01', numlist.id ) AS 'date' 
FROM
	(
	SELECT
		n1.i + n10.i * 10 + n100.i * 100 AS id 
	FROM
		num_temp_0225 n1
		CROSS JOIN num_temp_0225 AS n10
		CROSS JOIN num_temp_0225 AS n100 
	) AS numlist 
WHERE
	adddate( '2012-09-01', numlist.id ) <= '2012-09-2';

---

sqlserver

select convert(varchar(30), dateadd(day,  number, '2022-02-01'), 23) as CreatedOn
                       	    from master..spt_values
                       	    where dateadd(day,  number, '2022-02-01') <= '2022-02-28'
                       	      and type='p' and number>=0

效果：