Mike Martin wrote:
>>> select tsid from recordings where '2010-03-16 23:05:00' between start and
>>> end'
>
> It should return nothing because the time 2010-03-16 23:06:00 is later
> than the end time of 2010-03-16 23:05:00
I don't see 23:06 anywhere in your statement nor in your data.
--
Igor
On Wed, Mar 17, 2010 at 12:18:44PM +, Mike Martin scratched on the wall:
>
> >> select tsid from recordings where '2010-03-16 23:**05**:00' between
> It should return nothing because the time 2010-03-16 23:**06**:00 is later
> than the end time of 2010-03-16 23:**05**:00
Let me guess...
Mike Martin wrote:
> I am getting occasional incorrect results using between operator
>
> example
>
> table structure
> recordings
> ID
> tsid
> start
> end
>
> sample time= 2010-03-16 23:06:00
> sample start= 2010-03-16-22:00:00
> sample end= 2010-03-16 23:05:00
Do you actually have a dash
On 17. 3. 2010 11:49, Mike Martin wrote:
> sample time= 2010-03-16 23:06:00
> sample start= 2010-03-16-22:00:00
> sample end= 2010-03-16 23:05:00
> select tsid from recordings where '2010-03-16 23:05:00' between start and end'
>
> This query should return nothing, so can anyone explain why it is
On 17 Mar 2010, at 10:49am, Mike Martin wrote:
> sample time= 2010-03-16 23:06:00
> sample start= 2010-03-16-22:00:00
> sample end= 2010-03-16 23:05:00
> select tsid from recordings where '2010-03-16 23:05:00' between start and end'
>
> This query should return nothing, so can anyone explain
5 matches
Mail list logo