Is it possible to interchange numbers inside a column of a table?
The numbers are always the same length, that is, 8. Here an example:

```
^ before ^ after ^
|20150620|06202015|

```

It is a dateformat where I want to interchange the year at the end and the month at first.

Is it possible only on MySQL?

Thanks in advanced