SELECT
(
curdate() - INTERVAL (DAY (curdate())) DAY
) + INTERVAL s DAY AS dt
FROM
(
SELECT
1 AS s
UNION ALL
SELECT
2
UNION ALL
SELECT
3
UNION ALL
SELECT
4
UNION ALL
SELECT
5
UNION ALL
SELECT
6
UNION ALL
SELECT
7
UNION ALL
SELECT
8
UNION ALL
SELECT
9
UNION ALL
SELECT
10
UNION ALL
SELECT
11
UNION ALL
SELECT
12
UNION ALL
SELECT
13
UNION ALL
SELECT
14
UNION ALL
SELECT
15
UNION ALL
SELECT
16
UNION ALL
SELECT
17
UNION ALL
SELECT
18
UNION ALL
SELECT
19
UNION ALL
SELECT
20
UNION ALL
SELECT
21
UNION ALL
SELECT
22
UNION ALL
SELECT
23
UNION ALL
SELECT
24
UNION ALL
SELECT
25
UNION ALL
SELECT
26
UNION ALL
SELECT
27
UNION ALL
SELECT
28
UNION ALL
SELECT
29
UNION ALL
SELECT
30
UNION ALL
SELECT
31
) m
WHERE
s <= DAY (LAST_DAY(CURDATE()));
(
curdate() - INTERVAL (DAY (curdate())) DAY
) + INTERVAL s DAY AS dt
FROM
(
SELECT
1 AS s
UNION ALL
SELECT
2
UNION ALL
SELECT
3
UNION ALL
SELECT
4
UNION ALL
SELECT
5
UNION ALL
SELECT
6
UNION ALL
SELECT
7
UNION ALL
SELECT
8
UNION ALL
SELECT
9
UNION ALL
SELECT
10
UNION ALL
SELECT
11
UNION ALL
SELECT
12
UNION ALL
SELECT
13
UNION ALL
SELECT
14
UNION ALL
SELECT
15
UNION ALL
SELECT
16
UNION ALL
SELECT
17
UNION ALL
SELECT
18
UNION ALL
SELECT
19
UNION ALL
SELECT
20
UNION ALL
SELECT
21
UNION ALL
SELECT
22
UNION ALL
SELECT
23
UNION ALL
SELECT
24
UNION ALL
SELECT
25
UNION ALL
SELECT
26
UNION ALL
SELECT
27
UNION ALL
SELECT
28
UNION ALL
SELECT
29
UNION ALL
SELECT
30
UNION ALL
SELECT
31
) m
WHERE
s <= DAY (LAST_DAY(CURDATE()));