following is the SAP HANA SQL Query to display all month names from current year until date:
do
begin
declare i int := 0;
tMo = select '' mo from dummy;
while i < 12 do
tMo = select mo from (
select
MONTHNAME(add_months(now(), i)) mo from dummy
union
select mo from :tMo
);
i := i+1;
end while;
select * from :tMo;
end;
