Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Is this a good use for an IOT type table or are there bettersolutions.
In article <4061E2C0.F7F15374_at_remove_spam.peasland.com>, Brian Peasland <dba_at_remove_spam.peasland.com> wrote:
>> 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
>
>
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
Received on Thu Mar 25 2004 - 10:06:16 CST
![]() |
![]() |