calculate number of days excluding weekends

sudheer05 · Post by **sudheer05** » Mon Nov 27, 2006 2:06 pm

Hi,
My input has two timestamps,I need to calculate the number of days between these two timestamps excluding weekends.
Any help would be appreciated.
My source is Orcale.
ThankYou,
Sudheer.

ray.wurlod · Post by **ray.wurlod** » Mon Nov 27, 2006 2:08 pm

You can use Oracle functions or you can use DataStage.
If you use DataStage you will need either a (parallel) routine or a calendar table to determine which days are weekends. This is particularly true if your requirement extends the definition of "weekend" to include "holiday".

sudheer05 · Post by **sudheer05** » Tue Nov 28, 2006 11:15 am

Thanks Ray,
Yes I do have a Calender Table which has a Calendar date and a flag field which tells me if it is a working day or a holiday.
But I need some help to count these flags for which this calendar date lies between my date1 and date2 from the source.
ThankYou.

roy · Post by **roy** » Tue Nov 28, 2006 11:25 am

Hi,
I was wondering how can a 7.5.1a be parallel?
It certainly can't run those kind of jobs!

Most simple way is to use a sql join to calculate it from the calendar table

IHTH,

ajith · Post by **ajith** » Tue Nov 28, 2006 1:06 pm

select count(*) from Hol_Tab where hol_ind <>'Y'

or something like that?

It is just a matter of a query anyway