MySQL Forums
Forum List  »  Stored Procedures

Re: Stored procedure, holidays
Posted by: Peter Brawley
Date: July 17, 2014 08:56AM

A calendar-calculating algorithm most always is best started with a calendar table with one row per date in the relevant date range. For how to make such a table see "Make a calendar table" at http://www.artfulsoftware.com/queries.php.

For approaches to finding working & nonworking days bzsed on a calendar, see several examples under "Date an Time" and the same site.

Options: ReplyQuote


Subject
Views
Written By
Posted
2509
July 17, 2014 01:03AM
Re: Stored procedure, holidays
1267
July 17, 2014 08:56AM
1128
July 18, 2014 05:03AM
982
July 18, 2014 12:24PM


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.