SQL中两个日期之间的差异 [英] Difference between two dates in sql

问题描述

我想计算两个日期之间的差值，例如:

I want to calculate difference between two dates, something like:

SELECT TO_DATE('22-NOV-08')-TO_DATE('25-AUG-2008') FROM DUAL;

得出的89是此89中包含的 TO_DATE('22 -NOV-08')和 TO_DATE('25 -AUG-2008')天?

which comes out to be 89 is the TO_DATE('22-NOV-08') and TO_DATE('25-AUG-2008') included in this 89 days ?

推荐答案

是的，区别在于天单位.这是日期算术

Yes, the difference is in units of days. Here is a tutorial for Date Arithmetic

这篇关于SQL中两个日期之间的差异的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！