select (case when now()::date between to_date(da.dat,'DDMMYYYY') and to_date(da2.dat2,'DDMMYYYY') then CONCAT(extract(year from now()),'/',(extract(year from now())+1),'/Зимски') else (select case when now()::date between to_date(da1.dat,'DDMMYYYY') and to_date(da3.dat2,'DDMMYYYY') then CONCAT((extract(year from now())-1),'/',(extract(year from now())),'/Зимски') else CONCAT((extract(year from now())-1),'/',extract(year from now()),'/Летен') end
from (select CONCAT('0101',extract(year from now()))as dat)as da1,(select CONCAT('1402',extract(year from now()))as dat2) as da3)end
) as SEMESTAR
   from (select CONCAT('0110',extract(year from now()))as dat)as da,(select CONCAT('3110',extract(year from now()))as dat2) as da2