AT&T? Probably the day of. I don't think there's going to be too much hype so that you have to wait the day before (but I dunno).
Now the Apple store...
I'm going in during the middle of the day...they didn't run out for the first generation, I don't think they'll run out with the 3G iPhone.