在计算日期之间的差异时如何查找周六，周日 [英] how to find saturday, sundays during the calculation of difference between dates

问题描述

我正在编写一个查询，该查询将计算包括假期在内但不包括星期六和星期日的日期之间的差异.任何人都可以帮我吗

I am writting a query which will calculate difference between dates including holidays also but excluding saturdays and sundays.. can anybody help me

推荐答案

选中此

http://stackoverflow.com/questions/3450965/determine-if- oracle-date-is-on-a-weekend [ ^ ]

http://stackoverflow.com/questions/196171/oracle-10gr2-prevent-any-dates-that-fall-on-a Sunday [

Check this

http://stackoverflow.com/questions/3450965/determine-if-oracle-date-is-on-a-weekend[^]

http://stackoverflow.com/questions/196171/oracle-10gr2-prevent-any-dates-that-fall-on-a-sunday[^]

这篇关于在计算日期之间的差异时如何查找周六，周日的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！