how to generate a dates in sql

Question

i want to store leaveentry of employee

if employee takes leave from 03-01-17 to 03-05-17

i want to create date from

leavedate  

03-01-17

03-02-17

03-03-17

03-04-17

03-05-17