: [EMAIL PROTECTED]
Asunto: RE: getting the number of years between two dates
Actually figured out one of my own:
FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM
UserDOB))/ 12) as Age
It's amazing what you can think of as soon as you ask the question.
-Ori
Sent: Thursday, November 07, 2002 1:58 PM
To: John Meyer
Cc: [EMAIL PROTECTED]
Subject: Re: getting the number of years between two dates
John Meyer wrote:
>sql,query
>
>How do I do that? The contaxt is that I want to get somebody's age based
>upon the current date.
>
>
There
John Meyer wrote:
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
There are several examples in the mailing list archives; but try
subtracting the UNIX_TIMESTAMP of each date (which is the time in
seconds) and then divide by the nu
sql,query
How do I do that? The contaxt is that I want to get somebody's age based
upon the current date.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
At 3:05 PM -0300 6/26/01, Augusto Cesar Castoldi wrote:
>It's possible get the number of years between two dates in a mysql
>function?
That kind of depends on what you mean by the number of years between
two dates. For example, do you define the number of years between 2000-12-31
and 2001-01-01
: Getting the number of years between two dates
It's possible get the number of years between two dates in a mysql
function?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
It's possible get the number of years between two dates in a mysql
function?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc