Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: How can I convert epoch seconds to date format

by davorg (Chancellor)
on May 10, 2006 at 15:11 UTC ( [id://548482]=note: print w/replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://548482]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others surveying the Monastery: (3)
As of 2024-04-19 23:52 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found