Re: modeling year and month for summary data

Randy,
 We have both weekly and monthly summary tables and the date data field is defined as DATE. It is populated by the pl/sql package that summarizes the data using a date value passed to the package as the ending date for the week or month. On the first of the month or Sunday we run the appropriate package and pass the date value (sysdate -1) for the package to use as the ending date.
Ron

>>> RASTEIN_at_NYCT.com 11/14/2003 5:14:25 PM >>>
I have a table that will contain sales monthly summary. I am not sure which
is the better way to handle the date of the data. I can create a year field
and a month field or I can create a date field and force in the day e.g.
2003 November's data can be 01-Nov-03 .

Is there a censuses on which way to handle the date?

Thanks
Randy

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net 
-- 
Author: Steiner, Randy
  INET: RASTEIN_at_NYCT.com 

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com 
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Ron Rogers
  INET: RROGERS_at_galottery.org

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).