The built-in time fields are automatically updated whenever mySQL creates or updates a record

That is only TIMESTAMP and only the first one in your table. You still have the DATETIME, DATE and TIME ones to choose from. It also allows you to have several timestamps, one which will always update (a "last modified") and others that only change when you want them too.

It's all about semantics, really. If you want to store a date or a time, store a DATE or a TIME. If you want to stamp a certain time... Also, it never hurts to read up on what the manuals say instead of reinventing another wheel. As with Perl, you can often assume that good products already have the tools you need, and of better quality. Saves time and enhances overall quality.

In reply to Re^2: 5 minutes of time by Stoffe
in thread 5 minutes of time by Anonymous Monk

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.