Beefy Boxes and Bandwidth Generously Provided by pair Networks
Problems? Is your data what you think it is?
 
PerlMonks  

Re: How do I Compare Dates

by tenatious (Beadle)
on Jun 27, 2000 at 04:21 UTC ( [id://19937]=note: print w/replies, xml ) Need Help??


in reply to How do I Compare Dates

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
Domain Nodelet?
Node Status?
node history
Node Type: note [id://19937]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others pondering the Monastery: (5)
As of 2024-04-19 23:34 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found