HELP WITH SQL DATE FUNCTIONS

From: Daren Janes <daren_at_morgan.ucs.mun.ca>
Date: Wed, 3 Mar 1993 15:39:16 GMT
Message-ID: <C3BKts.1nL_at_news.ucs.mun.ca>

I have a need to calculate the number of Monday..Fridays between two dates. There isn't a function that I could see in the documentation. I have it working with a PL/SQL procedure that sequentially passes through the days in question and checks to see if its a Mondat..Friday. This is rather CPU intensive and I was wondering if there is a better way.

Thanks in advance

Daren L. Janes Received on Wed Mar 03 1993 - 16:39:16 CET

This message: [ Message body ]
Next message: MJW/TWF: "Re: HELP WITH SQL DATE FUNCTIONS"
Previous message: Paul S Mardle: "protecting multi-line rows from page breaks in SQL*Plus"
Next in thread: MJW/TWF: "Re: HELP WITH SQL DATE FUNCTIONS"
Reply: MJW/TWF: "Re: HELP WITH SQL DATE FUNCTIONS"
Reply: Mark McGregor: "Re: HELP WITH SQL DATE FUNCTIONS"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message