- 论坛徽章:
- 0
|
我想取procedure的运行时间enddate-begindate,但是取的两次时间都一样,时间差是0啊。逻辑如下:
建表:
create table daiwoo
(
userid varchar(100)
)
建procedure:
create procedure TestIv()
define i int;
define v_date,v_end datetime year to second;
define v_interval interval day to second;
set debug file to '/opt/informix/daiwoo/TestIv.trace';
let v_date=current;
let i=1;
trace 'procedure start on '||v_date;
for i=1 to 100000
insert into daiwoo values(i);
end for
let v_interval=current-v_date;
TRACE 'procedure end on '||v_end||'spent time total:'||v_interval;
end procedure;
运行procedure后发现trace的文件中的结束时间和起始时间一样,为何?
请高人执教,谢了 |
|