Although Perl offers the widest range of date conversion facilities - we are only scratching the surface so far, I feel it is only responsible to add that MySQL is also well-stacked with date-conversion functions. So whether to use Perl functions or MySQL functions for this depends more on the OTHER functionality you are dealing with (e.g. are stored procedures involved -- particularly if they have error-handling that if activated might obviate the need to convert in some cases -- and what other functionality is already implemented in Perl versus MySQL whose development should be encapsulated in just one place or the other?). So apart from the excellent suggestions by other posters, based on the limited information so far, it remains possible that you might want to include such MySQL functions as STR_TO_DATE in your list of contending solutions before making your choice of where/how to do this.

Update: reworded to make post more concise.

One world, one people

In reply to Re: How to convert date like: 19 Aug 12:00 PM EDT to a perl structure by anonymized user 468275
in thread How to convert date like: 19 Aug 12:00 PM EDT to a perl structure by ichudov

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.