Re: adding time to a date

[Quoted] In article <evl71tkm52nv8tfhtg3e9hfv45kjvtq9n3_at_4ax.com>,   l.bosman_at_wanadoo.be wrote:
> In Forms6, I'm having to field on screen:
> first one is end_time (date in format DD/MM/YYYY HH24:MI')
> second is supl_time (date in format HH24:MI)
> I must add the supl_time to the end_time, so I'm doing
> :end_time := :end_time + :supl_time
> But the result of that operation is 'error 306: wrong number or
> types of arguments in call to '+'
> How to proceed to add supl_time to end_time?
 

[Quoted] :end_time := end_time + (:supl_time - trunc(:supl_time))

You can only add number to a date.

>
> --
> Luc Bosman
> DEV/2000 Software Engineer
> Database & Network Administrator
> l.bosman_at_wanadoo.be ICQ 37011625
> http://users.skynet.be/kobukai/
> ----------------------------------------------------
> | -°) (°- |
> | /\\ Linux the choice of the GNU generation //\ |
> | _\_v v_/_ |
> ----------------------------------------------------
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 16 2000 - 19:07:56 CET