List:General Discussion« Previous MessageNext Message »
From:Keith C. Ivey Date:December 3 2002 8:28pm
Subject:Re: DateTime Calculations
View as plain text  
On 3 Dec 2002, at 10:45, Peter Abilla wrote:

> Column One              Column Two
> 1999-09-17 16:30:18     1999-09-18 13:30:18
> 
> I want to calculate the minutes like
> 
> (Column Two - Column One) = Total Minutes

Something like ( UNIX_TIMESTAMP(column2) - UNIX_TIMESTAMP(column1) ) / 60 ?

> Keyword: sql, query


-- 
Keith C. Ivey <keith@stripped>
Tobacco Documents Online
http://tobaccodocuments.org
Phone 202-667-6653
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