Re: Handling of Year wise data in Database Design
Posted by: Peter Brawley
Date: November 27, 2007 11:03AM

A common solution is to have
CREATE TABLE fiscalyears(
  yr YEAR -- eg 2007
  startdate DATE, -- eg 1 Apr 2007
  enddate DATE, -- eg 31 Mar 2008
  comment CHAR(128)
);
You keep a row for every fiscal year, and either maintain a yr column in all other tables or join to those tables on fiscalyears.yr=YEAR(revenue.datecol).

PB



Edited 1 time(s). Last edit at 11/27/2007 11:48AM by Peter Brawley.

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.