AnsweredAssumed Answered

Query of time range in Query Builder with Timestamp

Question asked by tmlai on Aug 18, 2014

I have a geodatabase to show some points with timestamp "yyyy-mm-dd hh:mm:ss". All data are in different data.

 

If I filter the data in a period of particular date and time, such as

 

SELECT * FROM LAYERNAME WHERE:

"DateTime" Between date '2014-01-22 07:28:35' AND date '2014-01-22 09:28:39'

 

It works.

 

But I would like to filter the data in time range in all different dates, 14:00:00 to 14:30:00 in ALL dates (such as 2014-01-22, 2014-01-23 and 2014-01-24 ...). How can I do?

 

I tried to use wildcard like 

"DateTime" Between date '%07:28:35' AND date '%09:28:39'

but it did not work.

 

Can any one suggest how to use query builder to filter the data in the particular time period in different dates?

Outcomes