]
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+ func
.cc> Fax to:
Subject: Re: Date/Time Difference
Calculations
06/11/2004 03:37
L PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Friday, June 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]
gt;
Sent: Friday, June 11, 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 i
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
>
d, SEC_TO_TIME(end - start) FROM table
>
>
> Eamon Daly
>
>
>
> - Original Message -
> From: "Dirk Bremer (NISC)" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, June 11, 2004 1:57 PM
> Subject: Date/Time D
(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 that represents a start time and the other that represen
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
ins
using the standard functions and
'col_name/100', but that will only be accurate to a second.
Regards
Quentin
-Original Message-
From: Andreas Karl Wittwer [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 6 March 2001 2:54 p.m.
To: [EMAIL PROTECTED]
Subject: Date/Time difference
Hell
Hello,
I'm reading this list for some time and checked the FAQ, archive
but i haven't found any hints ...
I have an own written app which is using a 'kind of database' to
calculate the difference between two (or more) events which can
happen between tens or hundreds of seconds.
Now i want to sw
10 matches
Mail list logo
