how to use pivot

Question

mydatat is like below 

 date(column name)

 03-01-17

 03-02-17

 03-0317

my expected output is

1

2

3

4

5