select convert(varchar(10),dateadd(day,number,'2016-05-01'),120) as DTime
from master..spt_values
where datediff(day,dateadd(day,number,'2016-05-01'), '2016-05-31')>=0
and number>=0
and type='p'
from master..spt_values
where datediff(day,dateadd(day,number,'2016-05-01'), '2016-05-31')>=0
and number>=0
and type='p'