Re: Is this a good use for an IOT type table or are therebettersolutions.

> the date we get is of the form '6/21/2003 00:00:00' they all default to 0
> hour regardless of the actual hour, to_char will just give us the zero hour

Then it looks to me like the data was inserted incorrectly. They should have inserted SYSDATE into this column, not TRUNC(SYSDATE). By doing so, an extra column was forced to be added to capture information that could have been captured correctly in one column.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"