Find Year difference in SQL

YEAR(CURRENT_DATE)-YEAR('1971-01-01') as years_now

Find Future Date from PHP

date("Y-m-d", strtotime(date('Y-m-d') . " +6 month"));