标题: informix存储过程获取当前时间问题 [打印本页] 作者: woo198888882012 时间: 2013-01-05 10:56 标题: informix存储过程获取当前时间问题 create procedure test()
returning datetime year to fraction(3),datetime year to fraction(3);
define time1 datetime year to fraction(3);
define time2 datetime year to fraction(3);
begin
let time1 = current;
insert into aip_message_persistence_test select * from aip_message_persistence where receive_time between today - 100 units day and today;
--这一个语句大约执行10秒多
let time2 = current;
return time1,time2;
end;
end procedure