Re: SQL Question:Age From Birthdate

Hi,

how about:

select floor(Months_between(sysdate, birthday)/12) from dual; ?

Michael Wallach schrieb:
>
> Does anyone know how using SQL I can determine someone's age based on
> their birthdate?
>
> Mike

--

Regards

Matthias Gresz :-)

GreMa_at_t-online.de Received on Wed May 27 1998 - 02:14:39 CDT