In article <406192C8.2DC4B560_at_remove_spam.peasland.com>, Brian Peasland <dba_at_remove_spam.peasland.com> wrote:
>> we have a table with following structure
>>
>> ID NUMBER NOT NULL,
>> DATESTAMP DATE NOT NULL,
>> HOUR NUMBER NOT NULL,
>> AAMP NUMBER,
>> BAMP NUMBER,
>> CAMP NUMBER,
>> CAT NUMBER
>>
>> it has a unique index on ID, DATESTAMP, HOUR. it is used for access and
>> aslo enforces uniqueness
>
>Silly question, but why is there a column called HOUR when there is a
>DATE column as well? The DATE column will hold the date and the time,
>including the hour. IS the HOUR column redudant or is there another use?
>
>Cheers,
>Brian
>
>
we get a date no hour and hour separtely
App that uses table expects date and hour separtely.
Received on Wed Mar 24 2004 - 12:52:04 CST
