比较两段SQL文的时间

来源：互联网发布：word mac 分割线编辑：程序博客网时间：2024/05/16 06:48

/* CREATE TABLE SKK.ZM_TEST ( STRTITLE CHAR(20), DATETIMENOW TIMESTAMP(6), TIMENOW NUMBER ) */

delete from zm_test

/ insert into zm_test values('start1',systimestamp,0)

/ ――＜SQL＿OLD＞――――――――――

--select ......

/ insert into zm_test values('start2',systimestamp,0)

/ insert into zm_test values('start3',systimestamp,0)

/ ――＜SQL＿NEW＞――――――――――

----select ......

/ insert into zm_test values('start4',systimestamp,0)

/ insert into zm_test select 'start5', systimestamp, to_number(substr((M2.datetimeNow-M1.datetimeNow),instr((M2.datetimeNow-M1.datetimeNow),' ')+7,2)) *1000+to_number(substr((M2.datetimeNow-M1.datetimeNow),instr((M2.datetimeNow-M1.datetimeNow),' ')+10,3)) from zm_test M1,zm_test M2 where M1.strTitle = 'start1' AND M2.strTitle = 'start2'

/ insert into zm_test select 'start6', systimestamp, to_number(substr((M2.datetimeNow-M1.datetimeNow),instr((M2.datetimeNow-M1.datetimeNow),' ')+7,2)) *1000+to_number(substr((M2.datetimeNow-M1.datetimeNow),instr((M2.datetimeNow-M1.datetimeNow),' ')+10,3)) from zm_test M1,zm_test M2 where M1.strTitle = 'start3' AND M2.strTitle = 'start4'

/ select strTitle , to_char(datetimeNow,'yyyy-mm-dd hh24:mi:ssxff'),timeNow from zm_test