MySQL :: Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

Posted by: Peter Brawley
Date: March 09, 2019 09:00PM

Given that you're using a database and sql, by far the simplest solution is to maintain a calendar table with a row for every day in the relevant range, then simply count rows between days excluding weekend days & holidays.

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Views

Written By

Posted

Recursively use a function to exclude Weekends and National Holidays to find a due date

5860

Pandit P

March 09, 2019 12:37PM

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

718

Peter Brawley

March 09, 2019 09:00PM

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

878

Pandit P

March 09, 2019 11:56PM

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

837

Peter Brawley

March 10, 2019 12:55PM

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

621

Pandit P

March 11, 2019 03:05AM

Re: Recursively use a function to exclude Weekends and National Holidays to find a due date

760

Alexandre Silva

December 20, 2019 10:08AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.