两个日期之间的天差 [英] days gap between two dates

问题描述

我想找出不包括星期日的两个日期之间的天数间隔.
如何在oracle中执行此操作?

请帮助我.

I want to find out the number of days gap between two dates excluding Sundays.
How can I do this in oracle?

Please help me.

推荐答案

我找到了确切的答案.
这是它的查询.

i found the exact answer for it.
Here is the query for it.

<br />
SELECT count(dt)   FROM<br />
(SELECT TO_DATE(''30-nov-2010'') + level - 1 dt FROM dual CONNECT BY level <=(TO_DATE(''12-Dec-2010'')-TO_DATE(''30-nov-2010'')))<br />
where to_char (dt,''D'')<>1<br />

我发现

I found THIS[^] discussion useful for getting business days count between dates. Make modification to your requirement accordingly.

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