convert row date column to column date

Question

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

Jitendra Shekhawat · Answer

http://stackoverflow.com/questions/30908882/conversion-of-date-string-and-time-string-into-datetime-in-c-sharp   http://stackoverflow.com/questions/39046827/convert-datetime-in-datarow-to-a-formatted-date-string     http://stackoverflow.com/questions/1106204/retrieving-a-datetime-value-from-a-datarow-c     http://stackoverflow.com/questions/19903204/date-is-converted-into-datetime-format-when-stored-in-datatable-ado-net     http://stackoverflow.com/questions/30908882/conversion-of-date-string-and-time-string-into-datetime-in-c-sharp