Hi
I quicly scanned through the FreeUDFLib and it appeard it has what you need.
You can download it from www.ibobjects.com or just search for it on google
it is maintained by Gregory Deatz I think.

If you dont want to go the udf lib then maybe someone else would have a
answer.

Groete
Gerhardus

> Hi All
>
> I have a procedure that I get a Date paramater and I have
> separate the year and month from the day and write to a table. I
> try to find a function for the pupose and I find extract,year and
> month functions but only names. There was no using example or any
> explanation for them in the LangRef.pdf, that I downloaded from
> borland's web site.
>
> CREATE PROCEDURE CARI_AY_ADDUPDATE (
> CARIID INTEGER,
> TARIH DATE,
> TIP SMALLINT,
> TUTAR NUMERIC(17,2))
> RETURNS (
> OLDU SMALLINT)
> AS
>
> suspend;
> end
>
> I have to parse the TARIH parameter.
>
> Any help will be very valuable.
>
> Burak