Let's upon that 'VALUE' is the amount in 'miliseconds' to increment. Then:

TIME=TIME+(VALUE/24/60/60/1000)

must work.

Luiz.

----- Original Message -----
From: Markus Ostenried <chef_007@...>
To: <ib-support@yahoogroups.com>
Sent: Saturday, April 21, 2001 9:51 PM
Subject: [ib-support] howto increment TIME


> Hi all,
>
> can anybody please tell me how to increment a TIME
> parameter by an amount of milliseconds in a stored proc ?
>
> TIA,
> Markus
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>