Query Run
select CONCAT(substr(rc_timestamp,1,4),"-",substr(rc_timestamp,5,2),... 3 years ago
select CONCAT(substr(rc_timestamp,1,4),"-",substr(rc_timestamp,5,2),... 3 years ago