Re: SQL*Plus-age
From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Mon, 14 Oct 2002 11:14:35 +0100
Message-ID: <aoe5ec$r1d$1_at_news.icl.se>
Date: Mon, 14 Oct 2002 11:14:35 +0100
Message-ID: <aoe5ec$r1d$1_at_news.icl.se>
Not directly. However, when you bear in mind that dates are really just floating point numbers (i.e the number of days since some designated year dot - does anyone know the reference date?) then you can simply subtract one date from another to get hte number of days between. Divide the result by 365 (adjust for leap years maybe) and you have your age.
"Bo" <esobolew_at_hotmail.com> wrote in message
news:186229a7.0210140103.3b0189ad_at_posting.google.com...
> Hi all !
> I`m using SQL*plus to write querys. Is there any command to deliver
> age from date of birth ?
> Thanks for any help
> Bo
Received on Mon Oct 14 2002 - 12:14:35 CEST