Its known that

SELECT 1 as head
will display single row with head as fieldname and 1 as value

Is there any way to generate multiple rows based on some range

For example i want to generate dates of particular month.
so it will be some 30 records generated without querying a particular table.