Re: Work hours?
Steve Atkins <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
> On Aug 27, 2019, at 11:27 PM, stan <[email protected]> wrote: > > I am just starting to explore the power of PostgreSQL's time and date > functionality. I must say they seem very powerful. > > I need to write a function that, given a month, and a year as input returns > the "work hours" in that month. In other words something like > > 8 * the count of all days in the range Monday to Friday) within that > calendar month. > > Any thoughts as to the best way to approach this? You might find this useful: https://gist.github.com/wttw/b6f5d0d67c31d499c05f22a4f2b6f628 It's not the most efficient approach, but it's relatively simple to customize. Cheers, Steve