incubator-couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sebastian Cohnen <sebastiancoh...@googlemail.com>
Subject Re: Map function to find docs in time interval
Date Mon, 19 Apr 2010 08:55:24 GMT
my first thought would have been emitting [2010, 01, 01, 5, 0, 0, 2010, 01, 01, 6 , 0, 0] and
query with startkey=[2010, 01, 01, 4, 59, 59, 2010, 01, 01, 6, 0, 1] to get documents between
2010-01-01 05:00:00 and 2010-01-01 06:00:00

On 19.04.2010, at 10:25, Peter Frisch wrote:

> I have documents that contain two timestamps (visitor entrance time and visitor time
of exit). Now I'm trying to write a map function that would allow me to find out which visitors
have been "in" at a specific given time. Any suggestions how I would do that?
> 
> Right now the timestamps are given as arrays containing year, month, day, hour, minute,
second, UTC offset but that could be changed if that doesn't seem to be a wise decision.
> 


Mime
View raw message