> -----Original Message----- > From: Eric Lommatsch [mailto:ericl@xxxxxxxxxxxxxxx] On Behalf Of Eric > Lommatsch > Sent: Friday, December 30, 2011 12:31 PM > To: Fatih P.; admin@xxxxxxxxxxxxxxxxxxx > Cc: 'Frank Arensmeier'; 'Eric Lommatsch'; php-general@xxxxxxxxxxxxx > Subject: RE: Re: Question about date calculations > > > Actually for what I need this is exactly what i was looking for. I am > converting an asp page that was calculating this difference using VBA > functions and I was trying to duplicate things as they were in that > page. > > > > > Thank you > > > > > Eric H. Lommatsch > Programmer > Pivotal Data Incorporated > 2087 South Grant Street > Denver, CO 80210 > Tel 303-777-8939 Ext 23 > Fax 888-282-9927 > > > > > www.pivotaldata.com > > > > > ericl@xxxxxxxxxxxxxxx > > > > > > -----Original message----- > From: Fatih P. <fatihpiristine@xxxxxxxxx> > Sent: Thu 29-12-2011 16:16 > To: admin@xxxxxxxxxxxxxxxxxxx; > CC: 'Frank Arensmeier' <farensmeier@xxxxxxxxx>; 'Eric Lommatsch' > <ericl@xxxxxxxxxxxxxxx>; php-general@xxxxxxxxxxxxx; > Subject: Re: Question about date calculations > > > > On 12/30/2011 12:19 AM, admin@xxxxxxxxxxxxxxxxxxx wrote: > -----Original Message----- From: Fatih P. [ > mailto:fatihpiristine@xxxxxxxxx ] Sent: Thursday, December 29, 2011 > 5:10 PM To: Frank Arensmeier Cc: Eric Lommatsch; php- > general@xxxxxxxxxxxxx Subject: Re: Question about date > calculations On Thu, Dec 29, 2011 at 11:40 PM, Frank Arensmeier > <farensmeier@xxxxxxxxx> wrote: > > 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 > > to > > 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 > > fits > > your bill. Or is there any particular reason why you're writing your > > "own" > > 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 > calculation 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); > http://dev.mysql.com/doc/refman/5.5/en/date-and-time - > functions.html#function_datediff > > 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[10]); > $dteEndDate[$intCnt] =new DateTime($row[11]); $interval = > $dteStartDate[$intCnt]->diff($dteEndDate[$intCnt]); echo $interval- > >format('%R%a days'); > > well then look deeper in the question: > > "I have a page I am trying to create where I am comparing the values of > two > MySQL date fields with the current date. One of the MySQL Date fields > is a class start date, the other is the class end date." > > all needs to do is modify his query. Thank you Eric, Date conversion is a popular issue when converting the language from one to the next. I prefer to manage any date filtering outside of MySQL because sometimes the fields are not clean or formatted correctly, and the DATEDIFF() of MySQL just fails. This failure can be devastating when dealing with a MySQL replication setup. I gauge the MySQL process against the PHP process and determine which is faster and which do I have more effective controls in. I have found I have better flexibility and control of date filtering in PHP. But squirrels will be squirrels... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
