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]
