Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Question:Age From Birthdate

Re: SQL Question:Age From Birthdate

From: Amin Adatia <amin_at_knowtech.on.ca>
Date: Wed, 27 May 1998 09:19:27 -0400
Message-ID: <896275297.448484@piano.synapse.net>


Hi!

SELECT months_between (sysdate,<date_column>)/12) from ..... should work. You might want to round the result.

<<< Check the exact syntax >>>>>>

Regards

Michael Wallach wrote in message <356B223E.4F91C946_at_totalsports.net>...
>Does anyone know how using SQL I can determine someone's age based on
>their birthdate?
>
>Mike
>
Received on Wed May 27 1998 - 08:19:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US