From: Peter Brawley
Date: April 27 2005 8:21pm
Subject: Re: getting hours from two datetime columns
List-Archive: http://lists.mysql.com/mysql/183264
Message-Id: <426FF435.9030308@earthlink.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
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