- Original Message -
From: "Mike Aubury" <[EMAIL PROTECTED]>
To: ; "Mike Blezien" <[EMAIL PROTECTED]>
Cc: "Jerry Schwartz" <[EMAIL PROTECTED]>
Sent: Monday, June 25, 2007 3:44 PM
Subject: Re: Birthday format
I might be wrong - but isn&#
; - Original Message -
> From: "Jerry Schwartz" <[EMAIL PROTECTED]>
> To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
>
> Sent: Monday, June 25, 2007 3:01 PM
> Subject: RE: Birthday format
>
> > mysql> S
thanks, worked prefectly,
Mike
- Original Message -
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'MySQL List'"
Sent: Monday, June 25, 2007 3:01 PM
Subject: RE: Birthday format
the-infoshop.com
www.giiexpress.com
www.etudes-marche.com
> -Original Message-
> From: Mike Blezien [mailto:[EMAIL PROTECTED]
> Sent: Monday, June 25, 2007 2:48 PM
> To: MySQL List
> Subject: Birthday format
>
> Hello,
>
> we have a simple query to calculate someones
Chris,
- Original Message -
From: "Chris Boget" <[EMAIL PROTECTED]>
To: "Mike Blezien" <[EMAIL PROTECTED]>; "MySQL List"
Sent: Monday, June 25, 2007 2:15 PM
Subject: Re: Birthday format
we have a simple query to calculate someones birt
we have a simple query to calculate someones birthday:
SELECT (TO_DAYS(CURDATE()) - TO_DAYS('1952-10-06')) / 365;
= 54.75
Now is there away, using SQL, to remove the .75 without rounding off. we
just want the '54' value. We can do it easy enough with our Perl
programming, but was wondering if th
Hello,
we have a simple query to calculate someones birthday:
SELECT (TO_DAYS(CURDATE()) - TO_DAYS('1952-10-06')) / 365;
= 54.75
Now is there away, using SQL, to remove the .75 without rounding off. we just
want the '54' value. We can do it easy enough with our Perl programming, but was
won
