SELECTing working days

gtk · #1 (**permalink**) 12-15-05, 08:36

I'd like to get the list of working days between to dates without having to use my script langage.
This is in order to LEFT JOIN it to a table containing some figures by day.

Example:
between 2005-12-18 and 2005-12-25
Here are my figures

Code:

2005-12-20 | 5
2005-12-22 | 3
2005-12-23 | 2

Here is what i'd like to have generated (working days between 2005-12-18 and 2005-12-25)

Code:

Here will be the LEFT JOINt result

Code:

2005-12-19 |
2005-12-20 | 5
2005-12-21 |
2005-12-22 | 3
2005-12-23 | 2

felixg · #2 (**permalink**) 12-15-05, 14:56

Quote:

Originally Posted by gtk

I'd like to get the list of working days between to dates

Use a calendar table. See http://www.dbforums.com/t981086.html
--
felix

Internet Services

Web Development

Digital Marketing

Consumer Tech