6

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:

select 
   id as [User Link],
   age
from Users
Where 
    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. – Richard J. Ross III Apr 30 '13 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 :) – Frédéric Hamidi Apr 30 '13 at 22:30
  • @FrédéricHamidi no resentment is to be had here. It's just another bug that should be fixed. – Richard J. Ross III Apr 30 '13 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 '13 at 22:45
  • Caching. Always caching. – user206222 Apr 30 '13 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. – Richard J. Ross III Apr 30 '13 at 23:48
  • To be honest, that was sarcasm. But, more seriously, are you older than 16.5 years? – user206222 Apr 30 '13 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. – Richard J. Ross III May 1 '13 at 0:01
  • Indeed, however, rounding is probably what's happening here. Try me - do I show up 16 or 17? – user206222 May 1 '13 at 0:05
  • @Knights You also appear as 17 in the explorer: data.stackexchange.com/stackoverflow/query/… – Richard J. Ross III May 1 '13 at 0:12
  • 1
    Then they're very likely rounding instead of flooring. – user206222 May 1 '13 at 0:26
  • 1
    This bug report is no longer relevant since birthday, and age, have been hard deleted in the database level. – Shadow Wizard is Ear For You Jun 10 '18 at 19:21

Browse other questions tagged .