It depends. I'd say most beer is no longer green four weeks after bottling, but bigger beers take longer. I tried a bottle of my trappist on new year's eve, and it was good, but it's got a loooong way to go to be all the way there. I'm going to try to make it until the end of January before I try another bottle.
It almost seems like it would be possible to come up with some kind of math equation that would create a relationship between OG and length of time to no longer be green. Here's a basic one:
For every 0.001 above 1.000 for the original gravity, the beer needs one day from brewing before it is no longer green.
So a typical pale ale in the 1.045 range would need about six and a half weeks to be ready. That seems reasonable. Meanwhile, my 1.076 trappist would need two and a half months. Hey, I think I'm on to something! :rockin: