--- In IBObjects@y..., "Flipado" <arsoft@n...> wrote:

> Hans:
>
> Thank you very much. I did a search using EXTRACT in this place and
> got the answer. Why is not this function documented? I spend almost
> one day looking for this!
>
> Artur Anjos
>
>
> --- In IBObjects@y..., hans@h... wrote:
> > I believe to remember something like extract(year of ...)
> >

Yes, you need to add your UDF library to IB.
May be you could check with following page for some free UDF for IB
(http://www.ibphoenix.com/ibp_contrib_download.html)