Mike, First, I expect great things from you/anyone who can get other people to do their work for them <smile>. Secondly, you are not "done for today" unless you get the FUNCTION you asked for. So, here you go:
create or replace function add_minute (date_in in date) return date is
begin
return date_in+(1/24/60);
end;
/
select to_char(sysdate,'yyyy-mm-dd hh24:mi:ss') now,
to_char(add_minute(sysdate),'yyyy-mm-dd hh24:mi:ss') future
from dual;
NOW FUTURE
------------------- -------------------
2003-08-05 09:34:47 2003-08-05 09:35:47
Cheers,
Dave