in reply to How can I convert epoch seconds to date format

One other piece of advice from someone who has been badly burnt by this once or twice in the past...

If you're storing dates and times in a datebase, then always store the UTC time. Convert from your local timezone to UTC as you put records into the data and convert UTC back to your local timezone as you fetch records from the database. This is guaranteed to make your live easier in the long run.

--
<http://dave.org.uk>

"The first rule of Perl club is you do not talk about Perl club."
-- Chip Salzenberg

  • Comment on Re: How can I convert epoch seconds to date format