Re: adding and displaying times in oracle forms

Have you tried format masks?
Or possibly to_char(sysdate,'HH')

shahira wrote:

> I have a field which is set up as a date field in my oracle database -
> this appears in a block
>
> I would like to input a time - name of item is
>
> t.start_time
>
> then I would like to display a field as number of hours
>
> t.number_hours
>
> then i would like to add the two together to display a calculated
> field not to be stored in the database:
>
> :t.start_time+t.number_hours using a formula in the property palette
>
> Can anyone help, I am new to this and may be making a basic error
>
> thanks for your help in advance!
>
Received on Thu Apr 11 2002 - 16:23:51 CEST