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

>Well, this works fine for me:
>
>select *
>from bestelling
>where leverdatum > current_date - 140
>
>Where leverdatum > currentdate - 140 days...

I know this works!
BUt I need to subtract a Time passed to a stored proc as a parameter!
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]