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

This message: [ Message body ]
Next message: T.A.V.: "JDBC- Oracle thread problem"
Previous message: Bob Withers: "Re: Is OCI thread-safe?"
In reply to: Michael Wallach: "SQL Question:Age From Birthdate"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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