From: Christian Mack
Date: April 23 1999 7:25pm
Subject: Re: Difference od two datetime types
List-Archive: http://lists.mysql.com/mysql/2295
Message-Id: <3720C91A.B204E7AB@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

Ramakrishna Satyavolu wrote:
> 
> Hi!
> 
> This might be the wrong place for this question, so please excuse me if it
> is.. I was unable to figure out a way of finding the difference of two
> datetime quantities to a minute or so, in mysql..
> 
> Any help wil be greatly appreciated..
> 
> Thanks
> 
> Ramakrishna

Hi Ramakrishna

I think you search this:
SELECT 
	FROM_UNIXTIME( 
		( UNIX_TIMESTAMP('1999-04-23 21:20:05') 
		- UNIX_TIMESTAMP('1999-04-23 14:00:00')
		) 
	)

Tschau
Christian