| 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 Calculations | Peter Abilla | 3 Dec |
| • Re: DateTime Calculations | Rodney Broom | 3 Dec |
| • Re: DateTime Calculations | Cory Hicks | 3 Dec |
| • Re: DateTime Calculations | Keith C. Ivey | 3 Dec |
| • Re: DateTime Calculations | Steve Yates | 3 Dec |
| • Re: DateTime Calculations | Pablo | 3 Dec |
| • Re: DateTime Calculations | Jeff Kilbride | 3 Dec |