> 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)
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
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
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
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),
5 matches
Mail list logo