Jump to content

Counting working days between dates (DB2)


Recommended Posts

I 've got the following question:

How to build an UDF in DB2 (e.g. 9.7 on AIX) which is able to return the working days between two dates.

Somthing like this (pseudo code)

float countWorkingDays(fromDate, toDate, GermanFederalState)

I've got a lookup table for all the relevant holidays per state.

Plus, in Autoit I can calculate all the holidays.

So all I want to do is,

a ) calculate the days between date a and date b

b ) subtract saturdays and sundays

c ) subtract all the holidays of the given state, between date a and date b

d ) return the number of working days

Any idea how to achieve the goal?

Wrting an UDF in Java? SQL-PL?

Which way would you go?

Thanks in advance

Mega

Edited by Xenobiologist

Scripts & functions Organize Includes Let Scite organize the include files

Yahtzee The game "Yahtzee" (Kniffel, DiceLion)

LoginWrapper Secure scripts by adding a query (authentication)

_RunOnlyOnThis UDF Make sure that a script can only be executed on ... (Windows / HD / ...)

Internet-Café Server/Client Application Open CD, Start Browser, Lock remote client, etc.

MultipleFuncsWithOneHotkey Start different funcs by hitting one hotkey different times

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...