Beefy Boxes and Bandwidth Generously Provided by pair Networks
Syntactic Confectionery Delight

Answer: How do I Compare Dates

( #19937=categorized answer: print w/ replies, xml ) Need Help??

Q&A > dates and times > How do I Compare Dates contributed by tenatious

If the date you want to compare is in the same format as that you are pulling from the database, you might be able to perform a SELECT statement on it and let the database tell you which date is younger (or older).

This method requires a connection to a database, and might not be the fastest way, but if you are designing for portability, would require less packages be installed than going whole hog and installing Date::Manip.

You could also just compare the dates manually. I.e:

($d,$m,$y) = split /-/, $date; $dv1 = $d+31*$m+365*$y; ($d,$m,$y) = split /-/, $date_from_db; $dv2 = $d+31*$m+365*$y; if ($dv1 < $dv2) { something; ... ... done; }

Comment on Answer: How do I Compare Dates
Download Code
Log In?

What's my password?
Create A New User
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (4)
As of 2015-11-26 00:51 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (695 votes), past polls