I'm using MySQL version 4.0.18. I have two datetime columns in the same
table, one that represents a start time and the other that represents an end
time. I would like to write a query that will show the difference between
these two columns in a HH:MM:SS format. The values of the two columns as
PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:57 PM
Subject: Date/Time Difference Calculations
I'm using MySQL version 4.0.18. I have two datetime columns in the same
table, one that represents a start time and the other that represents an
end
time. I would like to write
Eamon Daly
- Original Message -
From: Dirk Bremer (NISC) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 1:57 PM
Subject: Date/Time Difference Calculations
I'm using MySQL version 4.0.18. I have two datetime columns in the same
table, one
Time Zone
636-922-9158 ext. 8652 fax 636-447-4471
[EMAIL PROTECTED]
www.nisc.cc
- Original Message -
From: Dirk Bremer (NISC) [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 14:29
Subject: Re: Date/Time Difference Calculations
Here is an example using sec_to_time. Note
, 2004 14:29
Subject: Re: Date/Time Difference Calculations
Here is an example using sec_to_time. Note that the results are
inconsistent
and sometimes inaccurate. It seems that when the difference is less than
one
minute, the result is correct, when it is over one minute, the result
11, 2004 14:50
Subject: Re: Date/Time Difference Calculations
select
sec_to_time(time_to_sec(transfer_end)-time_to_sec(transfer_start));
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
to:
Subject: Re: Date/Time Difference
Calculations
06/11/2004 03:37
PM
]
www.nisc.cc
- Original Message -
From: [EMAIL PROTECTED]
To: Dirk Bremer (NISC) [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, June 11, 2004 14:54
Subject: Re: Date/Time Difference Calculations
I didn't see where these were 4.1+ function so I think it will work. I
refer you