ORACLE与MSSQL计算时间差的SQL操作
1
--ORACLE
2select TRUNC((TO_DATE('2006-02-24 10:13:10','yyyy-mm-dd hh24:mi:ss')-TO_DATE('2006-02-23 10:11:10','yyyy-mm-dd hh24:mi:ss'))*24*60*60) msecond from dual;
3
4--MSSQL
5select datediff(s,'2006-02-23 10:10:10.000','2006-02-23 10:11:11.000') A;
--ORACLE2
select TRUNC((TO_DATE('2006-02-24 10:13:10','yyyy-mm-dd hh24:mi:ss')-TO_DATE('2006-02-23 10:11:10','yyyy-mm-dd hh24:mi:ss'))*24*60*60) msecond from dual;3
4
--MSSQL5
select datediff(s,'2006-02-23 10:10:10.000','2006-02-23 10:11:11.000') A;
