I need the same, I will get the difference between two dates in days prior to executing this query:
SELECT DATE_ADD('2025-01-01', INTERVAL seq DAY) FROM seq_0_to_99;
where the difference in days is 99 for this example.