Maybe i need to save it in some 'general' format ?

The "general way" is to use UTC, which is very close to what is called: Greenwich Mean Time (GMT). There is no practical difference between the two.

Use UTC for date/time storage and convert that when necessary for user presentation. UTC marches onward and never goes "backward".

In local time, a day may have just 23 hours or may have 25 hours. There can be even wild things like Samona which recently just "deleted one day" (Friday, Dec 30, 2011) when they decided to be on a different side of the "date-line" - a political decision. Samoa Date Change

When converting from UTC to local time there can be some ambiguities. Think about this 2 AM deal in the US when we either "spring forward" or "fall back". In some locales like mine, there is a special law that doesn't allow the bars to be open one hour later on that special day when the clocks get set back one hour at 2 am (closing time is normally 2am). But the UTC time marches onward, regardless of the local time.

In reply to Re: timestamp and summer time by Marshall
in thread timestamp and summer time by AlfaProject

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.