Work hours?

Поиск
Список
Период
Сортировка
От stan
Тема Work hours?
Дата
Msg-id 20190827222741.GB19306@panix.com
обсуждение исходный текст
Ответы Re: Work hours?  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: Work hours?  (Ron <ronljohnsonjr@gmail.com>)
Re: Work hours?  (Paul A Jungwirth <pj@illuminatedcomputing.com>)
Re: Work hours?  (Christopher Browne <cbbrowne@gmail.com>)
Re: Work hours?  (Steve Atkins <steve@blighty.com>)
Re: Work hours?  (Luca Ferrari <fluca1978@gmail.com>)
Re: Work hours?  (Uwe Seher <uwe.seher@gmail.com>)
Список pgsql-general
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?


-- 
"They that would give up essential liberty for temporary safety deserve
neither liberty nor safety."
                        -- Benjamin Franklin



В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: No warning/error trying to vacuum other session's temp table
Следующее
От: Ron
Дата:
Сообщение: Re: Work hours?