Nevermind…
Nevermind.. I changed my mind. I’m going to store all the times in the db as PST. If I store it as GMT, I can’t use jackshit. No GROUP BY, no YEAR(), MONTH(), etc..
As GMT, I need to coerce it when I INSERT and coerce when I SELECT out, plus I loose all of the stuff mentioned. At least with PST I get the above stuff (though I still need to coerce the data).
Sucks if I ever move out of the Pacific timezone. Oh yeah, the old times are still messed up. I could go and fix them all. Maybe later.