Example: 
my @data = ( "blah blah 6/20/2000 4:56 foo bar baz\n",
             "bling blang 20.6.2000 4:56 flzb gzrk\n" );

for my $string ( @data ) {
    $string =~ s{ (\d{1,2}) ([./])
                  (\d{1,2}) \2
                  (\d{4}) \s+ (\d{1,2}):(\d{2})
                }
                {
                  my @a=($2 eq ".") ? ($4,$3,$1) : ($4,$1,$3);
                  sprintf( "%s-%02d-%02d %02d:%s", @a,$5,$6 )
                }ex;

    print $string;
}

[download]
That is, whatever string variable happens to contain one of the two types of date format, apply the lengthy "s{}{}" substitution statement to that string.

UPDATE: Forgot to mention: if you have a string with more than one date in it (e.g. "from 1/2/2000 to 3/4/2000"), just change the "ex" at the end to "exg".

In reply to Re^3: Question on date formatting by graff
in thread Question on date formatting by KarthikK

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.