Thank you, Helen !



Joseph Osende

BP 5975

Pointe-Noire

Rép. du Congo



Tél : +242 670808

Mail : osendej@...

-----Message d'origine-----
De : Helen Borrie [mailto:helebor@...]
Envoyé : lundi 14 avril 2003 05:09
À : ib-support@yahoogroups.com
Objet : Re: [ib-support] extracting the year



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/







Yahoo! Groups Sponsor



ADVERTISEMENT

<http://rd.yahoo.com/M=245454.3115308.4434529.1728375/D=egroupweb/S=1705
115386:HM/A=1457554/R=0/*http:/ipunda.com/clk/beibunmaisuiyuiwabei>



<http://us.adserver.yahoo.com/l?M=245454.3115308.4434529.1728375/D=egrou
pmail/S=:HM/A=1457554/rand=340583830>


To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.



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