|Subject||Re: [IBO] Sorry for the "off topic" question but|
> (this is not an IBO Question, but... maybe some of you canYou will probably get better results by posting such queries to
> help me in this IB question)
> Question:If you are using IB6 there is an extract function. Documentation for
> 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)
this can be found in the IB6 release notes (from the beta
documentation) see: http://www.interbase2000.org/doc_user.htm
If you are using versions prior to IB6 you can either...
Use UDFs see http://www.cvalde.com/misc/packages_and_utilities.htm
or some people use small stored procedures that achieve this by
various manipulations. see