Re: Birthday format

thanks, worked prefectly,

Mike
----- Original Message -----
From: "Jerry Schwartz" <jschwartz@the-infoshop.com> To: "'Mike Blezien'" <mickalo@frontiernet.net>; "'MySQL List'" <mysql@lists.mysql.com>
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-infoshop.com
> www.giiexpress.com
> www.etudes-marche.com
>
>
>> -----Original Message-----
>> From: Mike Blezien [mailto:mickalo@frontiernet.net]
>> Sent: Monday, June 25, 2007 2:48 PM
>> To: MySQL List
>> Subject: Birthday format
>>
>> 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
>> wondering if this can be accomplished within the actual query itself.
>>
>> TIA,
>>
>> Mike(mickalo)Blezien
>> ===============================
>> Thunder Rain Internet Publishing
>> Providing Internet Solution that Work
>> http://www.thunder-rain.com
>> ===============================
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=jschwartz@the-infoshop.com
>>
>>
>
>
>

-- 
MySQL General Mailing List
For list archives: 
http://lists.mysql.com/mysql
To unsubscribe:    
http://lists.mysql.com/mysql?unsub=lists@pantek.com