Oracle DateStamp 类型时间相减,得到毫秒结果小例子:
-- Created on 11/6/2013 by ZHENG.LIU
DECLARE
-- Local variables here
i INTEGER := 1;
t_start TIMESTAMP;
t_end TIMESTAMP;
d_start DATE;
d_end DATE;
BEGIN
-- Test statements here
SELECT systimestamp INTO t_start FROM dual;
SELECT SYSDATE INTO d_start FROM dual;
-- WHILE (i < 100000) LOOP
--UPDATE dds_fms_config SET VALUE = 'N' WHERE NAME = 'XML_VALIDATION';
-- i := i + 1;
--END LOOP;
SELECT systimestamp INTO t_end FROM dual;
SELECT SYSDATE INTO d_end FROM dual;
--Print:
dbms_output.put_line('[Timestamp]t_start = ' || t_start);
dbms_output.put_line('[Timestamp]t_end = ' || t_end);
dbms_output.put_line('[Timestamp - String]t_start = ' ||
to_char(t_start, 'yyyy-mm-dd hh24:mi:ss.ff'));
dbms_output.put_line('[Timesta