This appears to be a re-occurrence (or it never was fixed) of this bug:

Age calculations are wrong in the data dump export

Basically, when running a Data.SE query, the age field seems to be always off by one, for example:

   id as [User Link],
from Users
    displayname like 'Richard J. Ross III'

User Link           age 
------------------- --- 
Richard J. Ross III 17  

I'm not 17 yet, my birthday happens to be in September, and it makes calculations like this almost impossible.

Can we get this re-fixed, or at least have an explanation for this discrepancy?

  • 1
    Please don't close this as a dupe of the linked question. Anna told me to re-post this. Apr 30, 2013 at 22:25
  • Do you mean you resent your age being rounded up? Don't worry, a few years from now you won't even notice this :) Apr 30, 2013 at 22:30
  • @FrédéricHamidi no resentment is to be had here. It's just another bug that should be fixed. Apr 30, 2013 at 22:34
  • Yeah, hm. See my comment on this duplicate (which I'm not casting a vote on this post for, since it itself was incorrectly closed, sigh...). I'd speculate that it has something to do with guessing birthdates, but I'm not sure that makes sense (and isn't easy to do some other way).
    – Tim Stone
    Apr 30, 2013 at 22:45
  • Caching. Always caching.
    – user206222
    Apr 30, 2013 at 23:41
  • @Knights usually I'd agree with you, but if that bug was fixed 3 years ago then I should have never been 17 in their database at all. Obviously it's a bug unrelated to caching. Apr 30, 2013 at 23:48
  • To be honest, that was sarcasm. But, more seriously, are you older than 16.5 years?
    – user206222
    Apr 30, 2013 at 23:52
  • @Knights Indeed I am, my birthday is September 29th, making me 16.583 years old. However, age is something that probably shouldn't be rounded. May 1, 2013 at 0:01
  • Indeed, however, rounding is probably what's happening here. Try me - do I show up 16 or 17?
    – user206222
    May 1, 2013 at 0:05
  • @Knights You also appear as 17 in the explorer: data.stackexchange.com/stackoverflow/query/… May 1, 2013 at 0:12
  • 1
    Then they're very likely rounding instead of flooring.
    – user206222
    May 1, 2013 at 0:26
  • 1
    This bug report is no longer relevant since birthday, and age, have been hard deleted in the database level. Jun 10, 2018 at 19:21


Browse other questions tagged .