Hello,
Is there a function to determine the difference between two dates? I am
asking so I can do some date verification for COPA.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thursday 06 February 2003 23:13, Rob Quenzer wrote:
> I have a function that I use to return the number of days between two
> dates. It worked fine on my Mandrake 7.0 server running PHP 4. I am
> trying to run it on a RedHat 8.0 box with the same version of PHP. On
> Mandrake, strtotime() and
I have a function that I use to return the number of days between two dates. It
worked fine on my Mandrake 7.0 server running PHP 4. I am trying to run it on a
RedHat 8.0 box with the same version of PHP. On Mandrake, strtotime() and mktime()
returned a negative number for dates prior to 1970
On Sat, 31 Mar 2001 20:07:10 +0600, ([EMAIL PROTECTED]) wrote:
>Dear Friends,
>
>I am accessing a MySQL database through PHP.
>
>I have to calculate the difference between todays date and the date
>obtained
>from MySQL database.
select to_days(curdate())-to_days(datefield) from table;
- Mark
Lots of ways to do it, here's one.
Convert them both to unix timestamps and subtract.
$nowstamp=mktime() ;
$result=mysql_query(SELECT UNIX_TIMESTAMP(mydatefield) AS dbdate FROM
mydatabase);
$row=mysql_fetch_array($result);
$dbdate=$row["dbdate"];
$thedifference=$nowstamp - $dbdate;
//above
Dear Friends,
I am accessing a MySQL database through PHP.
I have to calculate the difference between todays date and the date obtained
from MySQL database.
The Database string is in the form of \"-mm-dd\".
I have to convert the above string into unix timestamp so that i can calcualte
th
6 matches
Mail list logo
