Re: [sqlite] Problem with between clause and dates

2010-03-17 Thread Igor Tandetnik
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

Re: [sqlite] Problem with between clause and dates

2010-03-17 Thread Jay A. Kreibich
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...

Re: [sqlite] Problem with between clause and dates

2010-03-17 Thread Igor Tandetnik
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

Re: [sqlite] Problem with between clause and dates

2010-03-17 Thread Michal Seliga
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

Re: [sqlite] Problem with between clause and dates

2010-03-17 Thread Simon Slavin
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