Use UT and a ISO 8601 date/time format for your stored time stamp. That allows easy searching, sorting and general manipulation based on time. You probably then need to use Date::Manip or some other date/time module to present dates and times in the users locale, but that's generally much easier than trying to manage localised time in your database!