I have table with `columns` 

```
Year | Day | CreatedDate.

```

I want to update `CreatedDate column`, so day part like `CreatedDate=Day` and year part in `CreatedDate=Year`.

I tried with datepart function in update statement but wasn't succesful.How can I do it?