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,011 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
pattern matching in perl 2 101
perl split by | 2 90
batch script for automated email 12 101
Perl Untar File 1 27
In the distant past (last year) I hacked together a little toy that would allow a couple of Manager types to query, preview, and extract data from a number of MongoDB instances, to their tool of choice: Excel (http://dilbert.com/strips/comic/2007-08…
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…
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

895 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now