At 03:46 AM 14/04/2003 +0100, you wrote:

>Hello, List !
>
>
>
>Could you please tell me how to extract
>
>the value of the year from a regular DATE in the body
>
>of a stored procedure.

...
declare variable iYear integer;
...
select extract (year from aTable.aDateCol) from aTable
where.....
into :iYear;
...

heLen

>
>
>With regards,
>
>
>
>Joseph Osende
>
>BP 5975
>
>Pointe-Noire
>
>Rép. du Congo
>
>
>
>Tél : +242 670808
>
>Mail : osendej@...
>
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>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/