Louis,

In future support questions should really be posted to the IB-Support
list at Yahoogroups, this is really not a support list.

To your question, how accurate do you want the answer to be?

If all you want to age in years, then something like AGE = (TODAY -
BIRTHDAY) / 365.25 is a good approximation.

Anything more accurate than that without UDF, well I'll leave that to
the SQL gurus.


Sean

> -----Original Message-----
> From: Louis Werth [mailto:louis@...]
> Sent: Thursday, June 21, 2001 9:31 AM
> To: IBDI@yahoogroups.com
> Subject: [IBDI] Calculating Age of a person without using free udf's
>
>
> Hi, can anybody help me, I am trying to correctly calculate
> the age of a
> person if I have his birth date and today's date in a stored
> procedure. We
> are not allowed to use the Free UDF's to do it. (management decision)
>
> Any help will be appreciated
> Louis Werth
>