Re: SQL Question:Age From Birthdate

From: Stanley Fung <sfung_at_mdsi.bc.ca>
Date: Tue, 26 May 1998 13:54:31 -0700
Message-ID: <356B2C07.75E6@mdsi.bc.ca>

select trunc(trunc(sysdate-birthday)/365) from emp;

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

Stanley Fung                 | Software Analyst
Mobile Data Solutions Inc.   | Direct Line: (604)207-6290
Suite 135                    | Tel:         (604)270-9939
10551 Shellbridge Way,       | Fax:         (604)270-1310
Richmond, B.C.               | E-Mail:      sfung_at_mdsi.bc.ca
Canada V6X-2W9               | http://www.mdsi-advantex.com

------------------------------------------------------------

Received on Tue May 26 1998 - 15:54:31 CDT