Hi, I have a week worth of data in a view and there is already a date column: select `time` from dfs.views.`mytbl` limit 5; +------------------------+ | time | +------------------------+ | 2011-04-24 22:21:19.0 | | 2011-04-24 22:21:24.0 | | 2011-04-24 22:21:28.0 | | 2011-04-24 22:21:33.0 | | 2011-04-24 22:21:38.0 | +------------------------+ 5 rows selected (0.256 seconds)
Now if I want to query from time 18:00:00 to 23:00:00 on every day, what would be a good way to do it? Thanks -James
