Thanks Greg
works fine now....
----- Original Message -----
From: "Greg Luce" <[EMAIL PROTECTED]>
Date: Fri, 27 Feb 2004 13:50:39 -0500
To: CF-Talk <[EMAIL PROTECTED]>
Subject: RE: OT - Getting age from MySQL
Providing the date functions you used in the age calculation work try:
SELECT Name, dob
FROM cand
WHERE (year(current_date) - year(dob) -
(if(dayofyear(dob)>dayofyear(current_date),1,0))) < 1
Let me know,
Greg
-----Original Message-----
From: Spectrum WebDesign [mailto:[EMAIL PROTECTED]
Sent: Friday, February 27, 2004 1:35 PM
To: CF-Talk
Subject: OT - Getting age from MySQL
Hi all
our DB have a field with dob from our clients. I'm looking for a script
to calculate the age including WHERE clauses.
But MySQL give an error: Unknown column "Age" in where clause.
Please look:
SELECT
Name,
dob,
year(current_date) - year(dob) -
(if(dayofyear(dob)>dayofyear(current_date),1,0)) AS Age FROM cand WHERE
1=1 AND Age > 1
How to do that?
Thanx in advance
--
___________________________________________________________
Sign-up for Ads Free at Mail.com http://promo.mail.com/adsfreejump.htm
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- OT - Getting age from MySQL Spectrum WebDesign
- RE: OT - Getting age from MySQL Barney Boisvert
- RE: OT - Getting age from MySQL Greg Luce
- RE: OT - Getting age from MySQL Philip Arnold
- Spectrum WebDesign