-- zad 3 select sqrt(power(12.34,2)+power(77,1/3)),round(sqrt(power(12.34,2)+power(77,1/3))),trunc(sqrt(power(12.34,2)+power(77,1/3))) ,ceil(sqrt(power(12.34,2)+power(77,1/3))),floor(sqrt(power(12.34,2)+power(77,1/3))) from dual; -- zad 5 select sysdate+321,sysdate-321,floor(months_between(sysdate+321,sysdate-321)),trunc((sysdate+321)-(sysdate-321)/7) from dual; -- zad 7 select (timestamp' 2018-12-12 19:07:00'-timestamp'2015-02-15 22:04:19')year to month from dual; -- zad 11 select to_char(last_day(sysdate),'DAY D DD DDD W WW MONTH YYYY year') from dual; -- zad 15 select to_number(concat('987','654'))-123456 from dual; -- zad 16 select to_char(to_char(sysdate,'CC'),'RN') from dual;