List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:April 23 1999 7:25pm
Subject:Re: Difference od two datetime types
View as plain text  
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

Thread
Difference od two datetime typesRamakrishna Satyavolu23 Apr
  • Re: Difference od two datetime typesChristian Mack23 Apr