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
Gary Stainburn wrote:
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.
Don't know of one -
Kenneth Gonsalves wrote:
On 15-May-07, at 2:39 PM, Richard Huxton wrote:
Don't know of one - not sure what workday would mean in a global
sense. I mean, Mon-Fri in most European office settings, but you'd
include Sat in retail settings and in Islamic countries presumably
exclude Fridays.
On 15-May-07, at 2:39 PM, Richard Huxton wrote:
Don't know of one - not sure what workday would mean in a global
sense. I mean, Mon-Fri in most European office settings, but you'd
include Sat in retail settings and in Islamic countries presumably
exclude Fridays. Our local library shuts
Kenneth Gonsalves wrote:
On 15-May-07, at 2:39 PM, Richard Huxton wrote:
Don't know of one - not sure what workday would mean in a global
sense. I mean, Mon-Fri in most European office settings, but you'd
include Sat in retail settings and in Islamic countries presumably
exclude Fridays.
On Tue, May 15, 2007 at 09:51:34AM +0100, Gary Stainburn wrote:
Hi folks
I need to be able to add and subtract workdays, something like
select CURRENT_DATE - '3 work days'::interval;
Would that take holidays into account? (and wich ones?)
--
Hello
You can use functions from Orafce package
http://www.pgsql.cz/index.php/Oracle_functionality_%28en%29#PLVdate
sample:
SELECT plvdate.plvdate.default_holydays('czech');
SELECT plvdate.add_bizdays(CURRENT_DATE, 10);
SELECT plvdate.isbizday('2006-12-25');
Regards
Pavel Stehule
On Tuesday 15 May 2007 10:17, Richard Huxton wrote:
Kenneth Gonsalves wrote:
On 15-May-07, at 2:39 PM, Richard Huxton wrote:
Don't know of one - not sure what workday would mean in a global
sense. I mean, Mon-Fri in most European office settings, but you'd
include Sat in retail settings