- 论坛徽章:
- 0
|
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
执行这个存储过程是,返回的时间(time1,time2)是一致的,请问这个是什么原因.顺便问下,如何获取当前时间可以精确到毫秒的,current好像只能精确到秒。谢谢。 |
|