Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

No. of fortnights ?

557505Mar 23 2007 — edited Mar 24 2007
Hi All,

I urgently need a query for the following req:

I need a query which gives no. of fortnights between two date ranges. The fortnights should be calculated based on the no. of days in a month ( eg. if no. of days =28 then one fortnight=14
days).

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2007
Added on Mar 23 2007
12 comments
1,071 views