ORACLE:
create or replace procedure dbm.pr_SysTime(p_time out date) as
begin
p_time:=sysdate;
end;
create or replace procedure dbm.pr_SysTime(p_time out date) as
begin
p_time:=sysdate;
end;
DB2:
CREATE PROCEDURE pr_SysTime ( OUT p_time TIMESTAMP )
LANGUAGE SQL
BEGIN
--| p_time:=sysdate;
SET p_time = CURRENT TIMESTAMP ;
END