Query Run
select concat(year(now())-1,0101000000) 2 years ago
select concat(year(now())-1,"0101000000") 2 years ago
select concat(year(now()),"0101000000") 2 years ago
select concat(year(now()),"010100000000") 2 years ago
select year(now()) 2 years ago
select now() 2 years ago