workday function

Поиск
Список
Период
Сортировка
От Gary Stainburn
Тема workday function
Дата
Msg-id 200705150951.34928.gary.stainburn@ringways.co.uk
обсуждение исходный текст
Ответы Re: workday function  (Richard Huxton <dev@archonet.com>)
Re: workday function  (Reinoud van Leeuwen <reinoud.v@n.leeuwen.net>)
Re: workday function  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-sql
Hi folks

I need to be able to add and subtract workdays, something like

select CURRENT_DATE - '3 work days'::interval;

I can't see how to do this natively so I'm looking to write a function to do 
it and was wondering if anyone's already done it.

While Googling I've found that MS Excel has a workday function which seems to 
do what I want.

Any help would be appreciated.
-- 
Gary Stainburn
This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000     


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

Предыдущее
От: "Nemo Terry"
Дата:
Сообщение: Re: How to process inverted comma in "EXECUTE 'insert into xxx values(...)
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: workday function