RE: DATE INTERVAL question.

2002-07-29 Thread Steve Bradwell
: [EMAIL PROTECTED] Subject: Re: DATE INTERVAL question. Hi. On Mon 2002-07-29 at 11:35:03 -0400, [EMAIL PROTECTED] wrote: > > I am trying to run a query that will check to see if a time field is less > than the the time in the field plus ten minutes. This does not make sense. This wi

Re: DATE INTERVAL question.

2002-07-29 Thread Benjamin Pflugmann
Hi. On Mon 2002-07-29 at 11:35:03 -0400, [EMAIL PROTECTED] wrote: > > I am trying to run a query that will check to see if a time field is less > than the the time in the field plus ten minutes. This does not make sense. This will always be true: A < A + 10 <=> 0 < 10 <=> true > The fie

DATE INTERVAL question.

2002-07-29 Thread Steve Bradwell
Hi, I am trying to run a query that will check to see if a time field is less than the the time in the field plus ten minutes. The field must also be greater than 00:00:00. The query below executes without error but doesn't return rows. Can I do this or is there a better way. I'm using MySQL in c