I don't think there's a set age where you can say "my partying days are over". Isht, I remember partying with a bunch of 30-40 year olds last year (and dated one of them!

)
In the past 6 months or so, I've noticed that I get tired around 11 and I normally leave bars by midnight, though most are open till 2 and some are open till 4.
DVD nights, going out to dinner, watching a movie or even staying home to read a good book are ideal nights for me now. If I go to a club, it's because someone's in town or it's someone's birthday.
I look back on the crap I have done in recent years. I'd stay till the club closed at 4, didn't bother to sleep because I had to be in at work at 7, and even then I'd show up to work and class completely hungover. If I didn't go to work like that, everyone knew something was wrong. I had a different bar or club to go to every freaking night (except Mondays when I dried off).
Read my LJ and that's how 2002 was like. To be honest, I can't remember anything from 2000-2002.
If you're not ready to give up your hat yet, don't. Looking back it's hard to believe that I lived like that and I don't have any regrets, but damn I shouldn't have built up a tolerance like that...otherwise I coulda saved a ishtload of money.