Nico,

>
> I have a stored procedure with a date-input parameter. How could I minus
> that date with 1 year ?

you could subtract 365 or 366 from it; otherwise have a look at the
EXTRACT function.
HTH
--
____
_/\/ando