RE: OT - Getting age from MySQL

2004-02-27 Thread Philip Arnold
> From: Spectrum WebDesign > > 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)

RE: OT - Getting age from MySQL

2004-02-27 Thread Spectrum WebDesign
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

RE: OT - Getting age from MySQL

2004-02-27 Thread Greg Luce
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. Plea

RE: OT - Getting age from MySQL

2004-02-27 Thread Barney Boisvert
dayofyear(current_date),1,0)) > 1 > -Original Message- > From: Spectrum WebDesign [mailto:[EMAIL PROTECTED] > Sent: Friday, February 27, 2004 10:35 AM > To: CF-Talk > Subject: OT - Getting age from MySQL > > Hi all > > our DB have a field with dob from our clie

OT - Getting age from MySQL

2004-02-27 Thread Spectrum WebDesign
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),