- 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
mysql> SELECT FLOOR(54.75);
+--+
| FLOOR(54.75) |
+--+
| 54 |
+--+
1 row in set (0.05 sec)
Regards,
Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-info
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