Change the year component of an existing date in database

Hi all, 
I'm trying to look for the easiest way to convert the year component of an existing date in the database. Say I have a date of 'Jan 1 2000' in the database and I want it to become 'Jan 1 2022', what is the best date transformation to use for this? 

Currently my thinking is the following but I feel like there is a short cut:
* Break out year from 'now' by using format timestamp. 
* Break out day from the date in the database. 
* Break out month from the date in the database. 
* Parse it back into a timestamp to be written to the database. 

^^^ All the above are new variables but surely there is a short cut?
Other
4 replies