title: how to find number of days between current timestamp and login date
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/676824/how-to-calculate-the-difference-between-two-dates-using-php">How to calculate the difference between two dates using PHP?</a><br>
    <a href="https://stackoverflow.com/questions/2040560/how-to-find-number-of-days-between-two-dates-using-php">How to find number of days between two dates using php</a><br>
    <a href="https://stackoverflow.com/questions/2736784/how-to-find-the-dates-between-two-specified-date">How to find the dates between two specified date?</a>  </p>
  </blockquote>
  
  
  
  <p>i have three fields in my table</p>
  
  <pre><code> seeker
   name ....current_time.... login_date
  
  second field i have created through timestamp phpmyadmin
  type: timestamp
  default: current_timestamp
  </code></pre>
  
  <p>when seeker get registered his current_time automatically inserted by timestamp</p>
  
  <pre><code> third field is login_date filed. when user logins then this field is updated 
  
  //login date
  $login_date = date("Y-m-d");
  echo "login date"."".$login_date;
  $qry1 = "update seeker set login_date = '$login_date' where name='$uname'";
  $res1=mysql_query($qry1,$con);
  
  now current_date is like 
  "2012-04-10 21:58:01"
  
  and login_date is like
  "2012-05-02"
  </code></pre>
  
  <p>i want to find number of days between these two dates. i dont know how to subtract these dates because current_date includes time too.. or is there any other way to exclude time from current-date i-e it enters only date not time</p>