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

Another way the time is not added to the column is when someone inserts similar to the following:

INSERT INTO my_table(date_column) VALUES TO_DATE('01/01/01','MM/DD/YY');

In this case, no time was provided, so it truncated the date.

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"