I believe to remember something like extract(year of ...)

===================

Flipado wrote:

>
> (this is not an IBO Question, but... maybe some of you can help me in
> this IB question)
>
> Question:
>
> Is there any way to get the values from day/month/year of a Date
> field in a trigger.
>
> I need something like:
>
> MyYear = YEAR( new.MyDateField)
>
> Thanks in advance to all
>
> Artur Anjos
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/