Subject RE: [ib-support] Stored Procedure Question Again (NewBie)
Author Martijn Tonies
extract(month/day/year etc from


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]