Select begin end of the month

SELECT DATE('2023-05-08', 'start of month', '+1 month', '-1 day') UNION
SELECT DATE('2023-05-08', 'start of month');