in reply to timestamp and summer time

Timestamps are fine if you don't want to treat them as such in SQL, I'm also using them for lots of stuff where speed is of essence. But don't do date calculations on timestamps yourself, use Date::Calc and forget about all the gory details.