Re: Date and DateTime columns

> How do others handle this situation?
>

We go with "the other fraction" (two domains in our modelling tool): CREATE TABLE EXAMPLE (
  XXX_TS DATE,
  XXX_DT DATE CHECK (XXX_DT = TRUNC(XXX_DT)) )

The main reason for this is that _our_ definition of "Date Only" says it should not contain any time fraction. Other reasons for this includes cleaner SQL, use of indexes, etc.

My $.02... Received on Wed Jan 09 2002 - 03:00:42 CST