SQL> create table test(sdate1 timestamp, sdate2 timestamp);Table createdSQL> insert into test values(sysdate, sysdate - 1);1 row insertedSQL> commit;Commit completeSQL> select (sdate1 - sdate2) as col from test;COL --------------------------------------- +000000001 00:00:00.000000SQL> select cast(sdate1 as date) - cast(sdate2 as date) as col from test; COL ---------- 1SQL> drop table test;Table dropped
再计算
---------------------------------------
+000000001 00:00:00.000000SQL> select cast(sdate1 as date) - cast(sdate2 as date) as col from test; COL
----------
1SQL> drop table test;Table dropped