convert row date column to column date

Apr 5 2017 10:21 PM

i have a table like this attdate 03-01-17(mm-dd-yyyy) 03-02-17 my expected result is 1(dd) 2(dd) 3(dd) ...etc 31(dd) I want to convert rows into columns