In article <3C3BB7C4.3C7F3A9D_at_indra.com>, rereidy_at_indra.com says...
> What datatype are you propsing for the "XXX_DT" type columns? If you
> use DATE, you will not have solved anything. If you use a NUMBER or
> VARCHAR2 type, you will need to define a standard way to populate it,
> and of course train your entire world how to use it. IMHO, stick wit
> the default DATE datatype. Make ypur life simple and don't add to your
> own confussion.
>
We are using DATE, but that was not the issue. A date column can be
populated with a date, all times are 00:00:00 or a datetime value. The
discussion centered around how the dates would be populated. Either
populate all dates as datetime or make a distinction between date and
datetime columns, populating date columns with a truncated date and
datetime columns with a datetimestamp.
--
Jim Poe ( jpoe_at_fulcrumit.com )
Received on Wed Jan 09 2002 - 10:26:02 CST
