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
>>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
