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

[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: <[EMAIL PROTECTED]> 
<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 * 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 between 2 dates?
>
>Chris
>
>
>
>  
>

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

[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 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 * 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 between 2 dates?
>
>Chris
>
>
>
>  
>

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

[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 between 2 dates?

Chris



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php