You also could use the date-part function. http://drill.apache.org/docs/date-time-functions-and-arithmetic/#date_part-syntax
On Fri, Jul 31, 2015 at 9:47 AM, Jacques Nadeau <[email protected]> wrote: > I would think you could cast to time and then provide a time boundary. > > I don't remember the exact syntax but something like WHERE CAST(`time` as > TIME) > TIME '18:00:00' and CAST(`time` as TIME) < TIME '23:00:00' > > -- > Jacques Nadeau > CTO and Co-Founder, Dremio > > On Fri, Jul 31, 2015 at 9:29 AM, James Sun <[email protected]> wrote: > > > > > 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 >
