WITH RECURSIVE date_range AS ( SELECT date'2019-01-03' dateval, 0 mes /*start date, use cast(? as date) if you need a parameter */ FROM rdb$database UNION ALL SELECT DATEADD(MONTH,1,dateval), mes + 1 FROM date_range WHERE mes < 12 /* end date */ ) SELECT * FROM date_range;
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter