CODE EXAMPLE FOR SQL

spark sql concatenate string and int

select concat('01/01/', extract(year from current_timestamp()) - 5)
select concat('01/01/', 2020)