比较两个日期相差几天?

Question

to_date(今天,'yyyy/mm/dd')-to_date(昨天,'yyyy/mm/dd')

Answer 1

select trunc(date1-date2) from dual;
返回的数据为整数表示两个日期之间的天数

Answer 2

SQL> select sysdate-to_date('05/01/03','dd/mm/yy') from dual;SYSDATE-TO_DATE('05/01/03','DD
------------------------------
0.691863425925926SQL> select trunc(sysdate-to_date('05/01/03','dd/mm/yy')) from dual;TRUNC(SYSDATE-TO_DATE('05/01/0
------------------------------
0SQL>  select trunc(sysdate-to_date('04/01/03','dd/mm/yy')) from dual;TRUNC(SYSDATE-TO_DATE('04/01/0
------------------------------
1

Answer 3

select trunc(date1-date2) from dual;

Answer 4

select trunc(date1-date2) from dual;

Answer 5

试了一下,应该是
select trunc(date1)-trunc(date2) from dual;