extract(month/day/year etc from
current_date/current_timestamp/current_time/datecolumn)

Example:

select extract(month from current_date) from rdb$database


btw, don't use SUSPEND for non-selectable stored procedures.

Martijn Tonies


-----Oorspronkelijk bericht-----
Van: zeroptr [mailto:zeroptr@...]
Verzonden: woensdag 7 november 2001 14:16
Aan: IB - Support
Onderwerp: [ib-support] Stored Procedure Question Again (NewBie)


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.


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