Re: Difference od two datetime types

[Christian Mack]

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