Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to Get Every two weeks settlement --allways Wednesday

Re: How to Get Every two weeks settlement --allways Wednesday

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 28 Jul 2006 16:08:52 -0700
Message-ID: <1154128131.971980.86060@s13g2000cwa.googlegroups.com>


rjayanth_at_gmail.com wrote:
> Hi,
>
> I am trying to get solution for this. I need to get settlement every
> two weeks and it alwyas happens on "Wednesday"
>
> Example :To Day's Date Jul 19
>
> My output look like this
>
> Date Day
>
> Jul19 Wed
> Aug 2 Wed
> Aug 16 Wed
> Aug 30 Wed
> ....so on till End Date which is 30 years
>
> Kindly let me know ASAP
>
> Oracle Version:Oracle 9i, restriction no PL/SQL
>
>
> Regards
> Jay

You need a table with at least 780 rows in order to seed a counter, then it is just a matter of multiplying the counter by 14 to hit every other week: DBA_OBJECTS, USER_OBJECTS, etc. For example:

SELECT
  (TO_DATE('2006-07-19', 'YYYY-MM-DD') + (ROWNUM - 1) * 14) NEXT_DATE FROM
  DBA_OBJECTS
WHERE
  ROWNUM<=780;

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Jul 28 2006 - 18:08:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US