Home » SQL & PL/SQL » SQL & PL/SQL » finding the number of working days between the start day and end day (merged)
finding the number of working days between the start day and end day (merged) [message #241100] Mon, 28 May 2007 05:54 Go to next message
yeshwant.k
Messages: 2
Registered: May 2007
Junior Member
how to find the number of working days between the start_day and end_day ,here we need to exclude the holidays and weekends(saturaday,sunday)
holidays include
Year Month Day Name
2007 1 1 New Year’s Day
2007 1 2 New Year’s Day
2007 2 18 Chinese New Year
2007 2 19 Chinese New Year
2007 2 20 Chinese New Year
2007 4 6 Good Friday
2007 5 1 Labour Day
2007 5 31 Vesak Day
2007 8 9 National Day
2007 10 13 Hari Raya Puasa
2007 11 8 Deepavali
2007 12 20 Hari Raya Hji
2007 12 25 Christmas Day

thankx in advance
Re: Number of working days between start date ,end date [message #241102 is a reply to message #241100] Mon, 28 May 2007 05:59 Go to previous messageGo to next message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Read the thread Counting the number of business days between 2 dates on AskTom.

Regards
Michel
finding the number of working days between the start day and end day [message #241103 is a reply to message #241100] Mon, 28 May 2007 06:00 Go to previous messageGo to next message
yeshwant.k
Messages: 2
Registered: May 2007
Junior Member
how to find the number of working days between the start_day and end_day ,here we need to exclude the holidays and weekends(saturaday,sunday)
holidays include
Year Month Day Name
2007 1 1 New Year’s Day
2007 1 2 New Year’s Day
2007 2 18 Chinese New Year
2007 2 19 Chinese New Year
2007 2 20 Chinese New Year
2007 4 6 Good Friday
2007 5 1 Labour Day
2007 5 31 Vesak Day
2007 8 9 National Day
2007 10 13 Hari Raya Puasa
2007 11 8 Deepavali
2007 12 20 Hari Raya Hji
2007 12 25 Christmas Day

thankx in advance
Re: finding the number of working days between the start day and end day [message #241106 is a reply to message #241103] Mon, 28 May 2007 06:04 Go to previous message
Michel Cadot
Messages: 68722
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Don't multipost.

Regards
Michel
Previous Topic: CASE Expression
Next Topic: Materialized View question
Goto Forum:
  


Current Time: Thu Dec 12 07:15:27 CST 2024