I am using SQL Server 2008 and have the column `MyDate` that contains the date as `20141208`. Its type is user-defined (UTypeDate:varchar(8)), and I want to convert it to `08/12/2014`.

For example, given

```
MyDate (UTypeDate:varchar(8))
20141208
20141218
20141204
20141216

```

what I want is to write the query that will give me output as:

```
MyNewDate
08/12/2014
18/12/2014
04/12/2014
16/12/2014

```

How should I write the query for this?