List:General Discussion« Previous MessageNext Message »
From:Steve Yates Date:December 3 2002 8:44pm
Subject:Re: DateTime Calculations
View as plain text  
On Tue, 03 Dec 2002 10:45:57 -0600, Peter Abilla wrote:

>(Column Two - Column One) = Total Minutes

	Assuming this doesn't work :) perhaps 

select UNIX_TIMESTAMP(col2) - UNIX_TIMESTAMP(col1) as TimeDiff

This should give you an answer in seconds.  [sql]

 - Steve Yates
 - File not found. Should I fake it? (Y/N)

~ Taglines by Taglinator - www.srtware.com ~

Thread
DateTime CalculationsPeter Abilla3 Dec
  • Re: DateTime CalculationsRodney Broom3 Dec
  • Re: DateTime CalculationsCory Hicks3 Dec
  • Re: DateTime CalculationsKeith C. Ivey3 Dec
  • Re: DateTime CalculationsSteve Yates3 Dec
  • Re: DateTime CalculationsPablo3 Dec
  • Re: DateTime CalculationsJeff Kilbride3 Dec