> -----Original Message-----
> From: Fatih P. [mailto:fatihpirist...@gmail.com]
> Sent: Thursday, December 29, 2011 5:10 PM
> To: Frank Arensmeier
> Cc: Eric Lommatsch; firstname.lastname@example.org
> Subject: Re: [PHP] Question about date calculations
> On Thu, Dec 29, 2011 at 11:40 PM, Frank Arensmeier
> > 29 dec 2011 kl. 22.22 skrev Eric Lommatsch:
> > > So far in looking at the functions that are available at
> > > http://www.php.net/manual/en/ref.datetime.php I have not been able
> > figure
> > > out how to do what I need to do. Below is a snippet showing
> > approximately
> > > what I am trying to do.
> > On the same page you are referring, there are plenty of examples on
> how to
> > calculate the difference between two dates. Choose one and see if it
> > your bill. Or is there any particular reason why you're writing your
> > function?
> > http://www.php.net/manual/en/ref.datetime.php#78981
> > /frank
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> since you have everything in database tables why not to do this
> on database side which would be much appropriate place ?
> /* columns
> date_start = '2011-02-08';
> date_end = ' 2011-03-04';
> select DATEDIFF(date_end, date_start);
I looked at this answer and see the date is from an array of a database and not
2 fields with in the table.
While the DATEDIFF() is very useful in queries this will not help you unless
both fields are in the table.
Try this example
$dteStartDate[$intCnt] = new DateTime($row);
$dteEndDate[$intCnt] =new DateTime($row);
$interval = $dteStartDate[$intCnt]->diff($dteEndDate[$intCnt]);
echo $interval->format('%R%a days');
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php