select imestudent
,datumrod
,extract(year from age(datumrod::timestamp)) as starost
,(datumrod + (extract(year from current_date) - extract(year from datumrod))*interval '1 year')::date as ove_god
,((datumrod + ((extract(year from current_date) - extract(year from datumrod))*interval '1 year')::interval))-current_date as rodendan_za
from student