Ok Nando,

thanks, Nico

-----Oorspronkelijk bericht-----
Van: Nando Dessena [mailto:nandod@...]
Verzonden: maandag 11 juni 2001 14:40
Aan: ib-support@yahoogroups.com
Onderwerp: Re: [ib-support] YEAR question


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

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/