Adding Number With Date 1

[Afzaal82]

i have THREE FILEDS [ HOURS ] [START TIME] [ END TIME ].
HERE [HOURS] IS A NUMBER TYPE FILED. AND BOTH OTHER ARE OF TYPE DATE.
START TIME AND END TIME ARE PICKED FROM SYSDATE.
PROBLEM IS SYSTIME IS 8:00PM WE ENTER 2 IN THE [HOURS] FILED. NOW [START TIME] SHOULD REMAIN AT 8:00 PM BUT THE [END TIME] SHOULD GO AS BELOW

[END TIME] = [START TIME] + [HOURS]
I.E 10:00 = 8:00 + 2

KINDLEY GIVE ME THE CODE TO DO SO.
THANKING YOU IN ADVANCE.

 

[lewisp]

[tt]end_time := start_time + (hours/24);[/tt]