| 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 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 |