How can I compare two dates in PHP

Question

How can I compare two dates in PHP   The date is stored in the database in the following format      2011-10-2   If I wanted to compare today s date against the date in the database to see which one is greater  how would I do it   I tried this    today   date  Y-m-d     expire    row- gt expireDate   from db  if  today  lt   expireDate      do something      but it doesn t really work that way  What s another way of doing it

User · Answer

Just to compliment the already given answers, see the following example:

$today = new DateTime('');
$expireDate = new DateTime($row->expireDate); //from database



if($today->format("Y-m-d") < $expireDate->format("Y-m-d")) { 
    //do something; 
}

Update: Or simple use old-school date() function:

if(date('Y-m-d') < date('Y-m-d', strtotime($expire_date))){
    //echo not yet expired! 
}

User · Answer

You can convert the dates into UNIX timestamps and compare the difference between them in seconds    today date date  Y-m-d     entered date   POST  date     dateTimestamp1   strtotime  today date    dateTimestamp2   strtotime  entered date    diff   dateTimestamp1- dateTimestamp2    echo  diff  if   diff lt  0            echo  Enter a valid date

User · Answer

first of all  try to give the format you want to the current date time of your server    Obtain current date time   current date   getdate    Separate date and time to manage them as you wish     current date only    current date year   -   current date mon   -   current date mday    current time only    current date  hours        current date  minutes        current date  seconds      Compare it depending if you are using donly date or datetime in your DB    today    current date only      current time only   or   today    current date only   if  today  lt   expireDate    hope it helps

User · Answer

Here s a way on how to get the difference between two dates in minutes      set dates  date compare1  date  d-m-Y h i s a   strtotime  date1       date now  date compare2  date  d-m-Y h i s a   strtotime  date2        calculate the difference  difference   strtotime  date compare1  - strtotime  date compare2    difference in minutes    difference   60   echo  difference in minutes

User · Answer

I had that problem too and I solve it by    today   date  Ymd     expire   str replace  -        row- gt expireDate     from db  if   today -  expire   gt   NUMBER OF DAYS            do something

User · Answer

If all your dates are posterior to the 1st of January of 1970  you could use something like    today   date  Y-m-d     expire    row- gt expireDate    from database   today time   strtotime  today    expire time   strtotime  expire    if   expire time  lt   today time       do Something        If you are using PHP 5    5 2 0  you could use the DateTime class    today dt   new DateTime  today    expire dt   new DateTime  expire    if   expire dt  lt   today dt       Do something        Or something along these lines

User · Answer

This works because of PHP s string comparison logic  Simply you can check     if   startdate  lt   date      do something   if   startdate  gt   date      do something    Both dates must be in the same format  Digits need to be zero-padded to the left and ordered from most significant to least significant  Y-m-d and Y-m-d H i s satisfy these conditions

User · Answer

Found the answer on a blog and it s as simple as   strtotime date  Y   -01-01    -strtotime  newdate   86400   And you ll get the days between the 2 dates

User · Answer

in the database the date looks like this 2011-10-2   Store it in YYYY-MM-DD and then string comparison will work because  1     0   etc

User · Answer

If you want a date   date  to get expired in some interval for example a token expiration date when performing a password reset  here s how you can do    date    row- gt expireDate    date- gt add new DateInterval  PT24H        adds 24 hours   now   new  DateTime     if  now  lt   date       expired after 24 hours        But in your case you could do the comparison just as the following    today   new DateTime  Y-m-d      date    row- gt expireDate   if  today  lt   date       do something

User · Answer

today   date  Y-m-d     Y-m-d H i s  expireDate   new DateTime  row- gt expireDate     From db   date1 date create  today    date2 date create  expireDate- gt format  Y-m-d      diff date diff  date1  date2      echo  timeDiff  if  diff- gt days  gt   30       echo  Expired     else      echo  Not expired

User · Answer

I would nt do this with PHP   A database should know  what day is today   use MySQL- NOW   for example    so it will be very easy to compare within the Query and return the result  without any problems depending on the used Date-Types  SELECT IF expireDate  lt  NOW   TRUE FALSE  as isExpired FROM tableName

User · Answer

Here s my spin on how to get the difference in days between two dates with PHP  Note the use of     in the format to discard the time part of the dates  thanks to info from DateTime createFromFormat without time    today   DateTime  createFromFormat   Y-m-d   date  Y-m-d      wanted   DateTime  createFromFormat   d-m-Y    row  WANTED DELIVERY DATE      diff    today- gt diff  wanted    days    diff- gt days  if    diff- gt invert     0   days   -1    days   overdue      days  lt  0    true   false   print   lt  --       days  gt  0                days     -- gt  n

[php] How can I compare two dates in PHP?

Examples related to php

Examples related to date

Examples related to compare