Beefy Boxes and Bandwidth Generously Provided by pair Networks
Clear questions and runnable code
get the best and fastest answer
 
PerlMonks  

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?
Username:
Password:

What's my password?
Create A New User
Chatterbox?
[GrandFather]: It's a good day end here Corion. The start was somewhat less than average!
[Corion]: GrandFather: All's well that ends well? ;)
[GrandFather]: I'm fighting with a third party device our software is to support. The documentation for the device's SDK is quite a lot less than average and most of today was spent ...
[GrandFather]: discovering that one of the sensors for the device lies about the gain range it is using!
[GrandFather]: However, by the end of the day I had discovered its deceptions and now have it working correctly, so yes, all's well that ends well. :-D
[Corion]: GrandFather: Ah, (hardware) APIs - I have a similar situation with Chrome and its API... It is fairly underdocumented and I guess I have to hunt...

How do I use this? | Other CB clients
Other Users?
Others having an uproarious good time at the Monastery: (6)
As of 2017-08-24 07:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    Who is your favorite scientist and why?



























    Results (365 votes). Check out past polls.

    Notices?