Solved

Perl, convert date string from format mm/dd/yyyy (12/15/2010) to yyyy-mm-dd (2010-12-15)

Posted on 2010-09-11
3
1,022 Views
Last Modified: 2012-05-10
Perl,

How do I convert date string from format mm/dd/yyyy (12/15/2010) to yyyy-mm-dd (2010-12-15) using any of the Perl "date" library.  Because using the Perl "date", the date can be checked for validity.

0
Comment
Question by:rgbcof
  • 2
3 Comments
 
LVL 84

Accepted Solution

by:
ozo earned 84 total points
ID: 33655905
s#(\d+)/(\d+)/(\d+)#$3-$1-$2#
or
join'-',(split/\D/)[2,0,1];
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 166 total points
ID: 33655918
could u make use of strtotime?
something along these lines


      $newDate = date("Y-m-d", strtotime($dt));


where $dt is your original date
0
 
LVL 65

Assisted Solution

by:rockiroads
rockiroads earned 166 total points
ID: 33655922
u could possibly use mktime as well to create a date, not as good though
0

Featured Post

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

A year or so back I was asked to have a play with MongoDB; within half an hour I had downloaded (http://www.mongodb.org/downloads),  installed and started the daemon, and had a console window open. After an hour or two of playing at the command …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

776 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question