how to get data based on date range in redis

Viewed 15381

I have a log data in mysql

id |   value | date
1  |   10.2  | 2017-07-20 18:00:00
2  |   10.5  | 2017-07-20 18:00:01
3  |   10.3  | 2017-07-20 18:00:03

then transformed it into hash dan sorted set in redis. This is my hashes:

hmset mylog:1 id 1 value 10.2 date 1388534400 
hmset mylog:2 id 2 value 10.5 date 1388534401
hmset mylog:3 id 3 value 10.3 date 1388534402

and sorted set :

zadd log_date 1388534400 1
zadd log_date 1388534401 2
zadd log_date 1388534402 3

I want to perform query just like WHERE date beetween .... and ....

Is there any possible way to get data from hashes, based on date range in sorted set?

Thanks!

2 Answers
Related