Re: How do I change the default quaters in PL/SQL
From: DA Morgan <damorgan_at_psoug.org>
Date: Fri, 02 Jun 2006 15:06:43 -0700
Message-ID: <1149286004.760620_at_bubbleator.drizzle.com>
>
> Actually if he gets the ISO week number (which follows his
> requirements) and DIVs that through 13 (each quarter is 13 weeks) he
> only needs to take the classic case of week 53 into account.
> Pipelined functions are irrelevant in this case.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Date: Fri, 02 Jun 2006 15:06:43 -0700
Message-ID: <1149286004.760620_at_bubbleator.drizzle.com>
Sybrand Bakker wrote:
> On Fri, 2 Jun 2006 12:35:26 -0400, "Mark C. Stock" <mcstockX_at_Xenquery
> .com> wrote:
>
>> not a complete description, but it sounds like some sort of rounding to the >> next or previous monday based on the day of week the quarter starts/ends on >> >> so a combination of trunc, to_char, and next_day with a case or a decode >> should accomplish whatever the algorithm actually is ... which could then be >> encapsulated in a function
>
> Actually if he gets the ISO week number (which follows his
> requirements) and DIVs that through 13 (each quarter is 13 weeks) he
> only needs to take the classic case of week 53 into account.
> Pipelined functions are irrelevant in this case.
>
> --
> Sybrand Bakker, Senior Oracle DBA
Provided the organization's rules are that simple ... I agree.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Sat Jun 03 2006 - 00:06:43 CEST