List:General Discussion« Previous MessageNext Message »
From:Peter Brawley Date:April 27 2005 8:21pm
Subject:Re: getting hours from two datetime columns
View as plain text  
James,

 >Is there a way to get all of the hours between two datetime columns?

 >For example, if there is an entry that starts at 2005-4-1 3:00:00 and
 >the end is 2005-4-1 11:00:00 I would like to know that this enry was
 >used in hours 3 - 11, or for 8 hours.

TIMEDIFF( '2005-4-1 11:00:00', '2005-4-1 3:00:00' )

PB

>  
>


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.308 / Virus Database: 266.10.3 - Release Date: 4/25/2005

Thread
re: getting hours from two datetime columnsJames Black27 Apr
  • Re: getting hours from two datetime columnsPeter Brawley27 Apr