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


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