Member Avatar for MARKAND911

I want to find out days gap between two dates excluding sunday.
How can i do this in oracle.
Please help me.

  • 2 Contributors
  • 3 Replies
  • 86 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by MARKAND911

Recommended Answers

All 3 Replies

Member Avatar for debasisdas

you need to find a function for the purpose.

Member Avatar for MARKAND911

thanx Debasis.
But can help me in finding or making that function.

Member Avatar for MARKAND911

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

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.