Re: Anomaly in date subtraction

2004-09-21 Thread Eldo Skaria
+---+ > 1 row in set (0.00 sec) > > > Eamon Daly > > > > > - Original Message - > From: "Gleb Kozyrev" <[EMAIL PROTECTED]> > To: "Eldo Skaria" <

Re: Anomaly in date subtraction

2004-09-21 Thread Eamon Daly
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

Re: Anomaly in date subtraction

2004-09-21 Thread Eamon Daly
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

Re: Anomaly in date subtraction

2004-09-21 Thread Gleb Kozyrev
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

Re: Anomaly in date subtraction

2004-09-21 Thread Eldo Skaria
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

Re: Anomaly in date subtraction

2004-09-21 Thread Gleb Kozyrev
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]

Anomaly in date subtraction

2004-09-21 Thread Eldo Skaria
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