[Fwd: Re: [PHP-DB] convert 2 dates to number of hours]
| From: | José Moreira | Date: | Tue, 01 Oct 2002 11:41:06 +0000 |
| Subject: | [Fwd: Re: [PHP-DB] convert 2 dates to number of hours] | ||
| Groups: | php.db php.windows | ||
| Request: | Send a blank email to php-db+get-22123@lists.php.net to get a copy of this message | ||
-------- 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 <jmoreira@e-terno.net>
Reply-To: jmoreira@e-terno.net
To: Chris Boget <chris@wild.net>
CC: PHP-DB <php-db@lists.php.net>
References: <3D98698C.6080701@e-terno.net> <152e01c26894$00370710$8c01a8c0@ENTROPY>
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 calculations the work hours so thats what im trying to do, to make the reports more viable ....
Chris Boget wrote:
Hello, how can i calculate the number of hours between 2 dates,( $unixDateTimeTo - $unixDateTimeFrom ) * 60 * 60and 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 between 2 dates? Chris