Yes, there are many moving parts to time/date calculations!

I personally always use gmtime(), which is close to utc time.
There is a slight difference between gm and utc time, but not much.
The difference is so small that I don't want to argue about it.

I recommend using GM or UTC time for all values stored in a DB.
Use a a conversion module like Time::Piece for translation to
translate the DB time to a user time zone.

My local government had a problem with the fall time change.
This actually allowed bars to remain open for one extra hour on one day of the year.
They fixed that "problem".
gmtime() just marches onward- there is no "fall back".

In reply to Re^3: Question regarding Time::Piece and timezones by Marshall
in thread Question regarding Time::Piece and timezones by atcroft

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.