Viewing 3 posts - 1 through 3 (of 3 total)
Its not only Taiwan, England and Wales also puts the legal birthday of leaplings as Feb 28. I think it has to do with trying to keep the birthday...
March 11, 2008 at 12:52 pm
#788227
Lynn Pettis (3/6/2008)
but its important to note it makes a differnce when a leap year birthday actually (or legally) occurs in non-leap year - Feb 28 or March 1st.
So,...
March 6, 2008 at 4:55 pm
#786415
# 2 is the "most" correct but it needs to be changed to
FLOOR(CONVERT(decimal(9, 2), DATEDIFF(d, @dob, @today)) / 365.24219)
to maximize the "correctness"
I use
SELECT DATEDIFF(year, @dob, getdate()) -...
March 6, 2008 at 4:15 pm
#786401