Possible Duplicate:
Age calculations are wrong in the data dump export
Age field in database off by one

I was messing around a bit and then I did this query:


Compare that with my real profile:


The weird part is is that my reputation is incorrect (this is most likely the case because it doesn't get updated too often), but the really worrying part is that my age is incorrect!

This must be an error somewhere, because I have entered my birthdate as 13/11/1994, which obviously means my age is 17 (and this actually does get shown on my SO profile).

So what's up here?

  • 3
    +1 for saying that your age being off by one is a "serious flaw" =) – Josh Darnell Mar 7 '12 at 20:24
  • I see your problem: the code doesn't account for 13 months in the Netherlands! :-P (This is why I prefer using date '+%Y_%m_%d'.) – Jon Ericson Mar 7 '12 at 21:25

The Data Explorer is not updated immediately. The data you're seeing there is from February 1st. If you visit the homepage you can see all the sites and all the way to the right it lists a date with the phrase "most recent" below it. That's the date from which the data is current.

As for the age, most likely a bug. It's probably only calculating current year - birth year to come up with the value of 18. When I run the query for my user ID, it says I'm 21 even though my birthdate is April 8, 1991.

  • 6
    Even on February 1st I was born on 13/11/1994 :P – orlp Mar 7 '12 at 19:53
  • @nightcracker: The first paragraph only relates to the reputation. – animuson Mar 7 '12 at 19:54

Not the answer you're looking for? Browse other questions tagged .