By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
create function greatest(in a date, in b date) returns date
language sql
begin
if a > b then return a; end if;
return b;
end
select greatest(date '2021-07-01', date '2021-12-01') from sysibm.sysdummy1;
1 |
---|
2021-12-01 |