Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Answer: How do I Compare Dates

by tenatious (Beadle)
on Jun 27, 2000 at 04:21 UTC ( #19937=categorized answer: print w/replies, xml ) Need Help??

Q&A > dates and times > How do I Compare Dates - Answer 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; }

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 drinking their drinks and smoking their pipes about the Monastery: (8)
As of 2016-10-21 21:35 GMT
Find Nodes?
    Voting Booth?
    How many different varieties (color, size, etc) of socks do you have in your sock drawer?

    Results (291 votes). Check out past polls.