My Findings ...
--Kiran Kumar Gupta Killamsetty
(Linkedin Profile)
Home
Oracle Apps
Genral Topics
Pictures
World
Tips
Search This Blog
28 May 2008
Oracle SQL : Work Days- Between Dates
If you want to find Working Days between two DATES here is the SQL statement
select count(1) from (select :from_date + rownum -1 Datex from dba_objects
where :to_date > :from_date + rownum -2)
where to_char(datex,'D') not in ('1','7')
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
About Me
Kiran Killamsetty
View my complete profile
No comments:
Post a Comment