(postgreSQL database)

I have a date column that appears to be in the format of 'yyyy-mm-dd' firstly I'd like to convert that said column to 'yyyymm'.

After that I'd like to clone that column to another column within the same table which I'd call "year" and I'd need to have that in the format of 'yyyy' only.

I'm yet to find a simple solution that would apply to my case and that's basic enough, as I'm new to SQL in general.

In the end I'd like the columns to be like this (excluding the other existing columns)

```
   date /*already exists*/  year /*need to create*/
   201501                   2015
   201501                   2015
   201502                   2015
   201606                   2016

```

Cheers