Calculating Business Days Between two dates...

santhoshrms

New Member

Join Date: Jul 2008

Posts: 1
#1

Calculating Business Days Between two dates...

Jul 10 '08, 10:36 AM

I need to be able to determine the number of business days between two dates. Is there a function/Select Query in DB2 that can be used to do this? ...
Tags: None
spider007

New Member

Join Date: Jan 2007

Posts: 27
#2

Aug 4 '08, 12:28 PM

Not sure about business days, but number of days can be calculated by
days(col_date1) - days(col_date2)
where col_date1 & 2 are the date columns
Comment

Comment