here is some pseudo code, just use the proper date functions to test for
Saturday and Sunday
high_date date := sysdate;
low_date date := sysdate -88;
day_counter integer := 0;
begin
while high_date > low_date
loop
If high_date != Sunday or Saturday
then
day_counter := day_counter +1;
end if;
high_date := high_date -1;
end loop;
end;
On Mon, Oct 13, 2008 at 8:57 AM, Vlad <[EMAIL PROTECTED]> wrote:
>
> I know that datediff can be used to calculate the number of calendar
> days difference between two dates - problem is that I need to know the
> number of working days between two dates.
>
> It would probably be acceptable for me to have the number of weekdays
> between two dates.
>
> Any ideas anyone.
>
> TIA
> >
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
