Aurélien, > You can do that, but be aware that you're comparing strings of different > lengths. > One consequence is that you won't get timestamps from 2012-12-02.
I just checked some of my data and all of the stored strings are of the same length. Am I understanding you correctly here? e.g. "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-04T22:19:00+00:00" "expire":"2012-10-05T23:13:00+00:00" "expire":"2012-10-05T23:13:00+00:00" "expire":"2012-10-05T23:13:00+00:00" "expire":"2012-10-05T23:13:00+00:00" "expire":"2012-10-05T23:13:00+00:00" "expire":"2012-10-05T23:13:00+00:00" "expire":"2012-10-06T00:01:00+00:00" "expire":"2012-10-06T00:01:00+00:00" "expire":"2012-10-06T00:01:00+00:00" "expire":"2012-10-06T00:01:00+00:00" "expire":"2012-10-06T00:01:00+00:00" "expire":"2012-10-06T00:01:00+00:00" "expire":"2012-10-06T00:07:00+00:00" "expire":"2012-10-06T00:07:00+00:00" "expire":"2012-10-06T00:07:00+00:00" Regards, Carl On 8 Oct 2012, at 10:35, Aurélien Bénel <[email protected]> wrote: >> have a bunch of documents stored in Couch with expiry dates like this: >> "expire": "2020-07-28T15:13:00+00:00" >> (...) >> I'm then querying the data ranges like this: >> ?startkey="2012-10-02"&endkey="2012-12-02" > > You can do that, but be aware that you're comparing strings of different > lengths. > One consequence is that you won't get timestamps from 2012-12-02. > > This is because of the following alphabetical order: > 2012-10-01T8:00:00+00:00 > 2012-10-02 > 2012-10-02T9:00:00+00:00 > 2012-12-01T10:00:00+00:00 > 2012-12-02 > 2012-12-02T11:00:00+00:00 > > > Regards, > > Aurélien > >
