List:General Discussion« Previous MessageNext Message »
From:Mike Blezien Date:June 25 2007 6:48pm
Subject:Birthday format
View as plain text  

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.


Thunder Rain Internet Publishing
Providing Internet Solution that Work
Birthday formatMike Blezien25 Jun
  • Re: Birthday formatChris Boget25 Jun
  • Re: Birthday formatMike Blezien25 Jun
  • RE: Birthday formatJerry Schwartz25 Jun
  • Re: Birthday formatMike Blezien25 Jun
    • Re: Birthday formatMike Aubury25 Jun
  • Re: Birthday formatMike Blezien25 Jun