[Fwd: Re: [PHP-DB] convert 2 dates to number of hours]

2002-10-01 Thread José Moreira
Original Message Subject: Re: [PHP-DB] convert 2 dates to number of hours Date: Mon, 30 Sep 2002 16:43:14 +0100 From: José Moreira <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Chris Boget <[EMAIL PROTECTED]> CC: PHP-DB <[EMAIL PROTECTED]> References:

Re: [PHP-DB] convert 2 dates to number of hours

2002-09-30 Thread José Moreira
thank you for your help, i figured this out : SELECT id, to_days(t1.closedate) - to_days(t1.date) FROM tracking AS t1 ... yes i am .. whe are using the IRM for internal help desk and im creating event reports ... it only makes sense to include in the calculatio

Re: [PHP-DB] convert 2 dates to number of hours

2002-09-30 Thread Chris Boget
> Hello, how can i calculate the number of hours between 2 dates, ( $unixDateTimeTo - $unixDateTimeFrom ) * 60 * 60 > and better yet , the work hours ( example from 8.30am to 6pm excluding > weekends) This would be more involved. Are you trying to find out how many work hours there were betwe

[PHP-DB] convert 2 dates to number of hours

2002-09-30 Thread José Moreira
Hello, how can i calculate the number of hours between 2 dates, and better yet , the work hours ( example from 8.30am to 6pm excluding weekends) -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php