I have this piece of code:

```
select convert(varchar(5),datepart(dd,max(getdate())))

```

Which produces this result:

```
 Output: 5

```

So today is August 5, 2015. For example: the Day should have a 0 before the day if single digits. Example: if the date is June 4, 2015 it should display: 04 Day of June 2015.

How can I do this?