> On Aug 27, 2019, at 11:27 PM, stan <stanb@panix.com> 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