At 14.08 19/08/2002 +0200, you wrote:

>Sorry Marco, you may not like my answer, cause it is likely to give you
>more work than you expected.
>
> >I have to do
> >DELTA_TIME = CAST( <VariableDefinedAsANumber> AS TIMESTAMP );
> >right?
>
>No, you're dealing with two different things. A timestamp is a specific
>point in time, e.g. 19 August 2002 at 14:04:32.332, whereas what you are
>left with after having subtracted one timestamp from another is a duration.
>Casting this back to a timestamp is probably not what you want, and e.g. 19
>August 2002 at 14:04:32.332 - 19 August 2002 at noon would give you 30
>December 1899 at 02:04:32.332 (or something similar). Duration really is a
>number, and ought never to be treated as anything else.

OK so my need is this:
I give to a SP a TIME_DELTA
and it has to return me all records that have a field (ORA_INVIO) lower than
CurrentTime-P_DELTA

What can I do to achieve this result?
Regards
Marco

Best Regards,
Marco Lauria
STARMAX s.a.s.
TEL. +39-091-6880476
FAX. +39-091-6887202
MOB. +39-348-3547034

[Non-text portions of this message have been removed]