Query of time range in Query Builder with Timestamp

TL — Mon, 18 Aug 2014 08:23:42 GMT

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?

topic Query of time range in Query Builder with Timestamp in Data Management Questions

Query of time range in Query Builder with Timestamp