+---+
> 1 row in set (0.00 sec)
>
>
> Eamon Daly
>
>
>
>
> - Original Message -
> From: "Gleb Kozyrev" <[EMAIL PROTECTED]>
> To: "Eldo Skaria" <
uot;MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 21, 2004 2:31 PM
Subject: Re: Anomaly in date subtraction
On Wed, 22 Sep 2004 00:20:32 +0530, Eldo Skaria <[EMAIL PROTECTED]>
wrote:
That seems to be vague to me.
I would like to know how the time is converted to numb
uot;MySQL List" <[EMAIL PROTECTED]>
Sent: Tuesday, September 21, 2004 2:31 PM
Subject: Re: Anomaly in date subtraction
On Wed, 22 Sep 2004 00:20:32 +0530, Eldo Skaria <[EMAIL PROTECTED]>
wrote:
That seems to be vague to me.
I would like to know how the time is converted to numb
On Wed, 22 Sep 2004 00:20:32 +0530, Eldo Skaria <[EMAIL PROTECTED]> wrote:
> That seems to be vague to me.
> I would like to know how the time is converted to numbers? is it upto
> seconds or even beyond that?
> happier if resolved,
>
It is converted in such a way that looking at number we can ea
That seems to be vague to me.
I would like to know how the time is converted to numbers? is it upto
seconds or even beyond that?
happier if resolved,
Thanks in advance.
reg,
Eldo.
On Tue, 21 Sep 2004 21:46:02 +0300, Gleb Kozyrev <[EMAIL PROTECTED]> wrote:
> Time is converted to numbers then sub
Time is converted to numbers then subtracted.
--
With best regards, Gleb Kozyrev.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Everybody,
The following is my scenario:
mysql> select mop_id, job_id, end_time, start_time,
end_time-start_time from bjs_stat where sol_id = '';
+++-+-+-+
| mop_id | job_id | end_time| start_time