Re: Birthday format

> 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.

Wouldn't this work

SELECT FLOOR((TO_DAYS(CURDATE()) - TO_DAYS('1952-10-06')) / 365 ) AS age

? What version of mysql are you using?

thnx,
Chris

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