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

> we get a date no hour and hour separtely
>
> App that uses table expects date and hour separtely.

But the DATE datatype stores the hour in there as well. A simple TO_CHAR on this column will pull just the hour out for your app.

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"