thanks, worked prefectly,
Mike
----- Original Message -----
From: "Jerry Schwartz" <[EMAIL PROTECTED]>
To: "'Mike Blezien'" <[EMAIL PROTECTED]>; "'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:[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 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/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
