Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Date range queries not usable #105

Closed
lacion opened this issue May 23, 2013 · 4 comments
Closed

Date range queries not usable #105

lacion opened this issue May 23, 2013 · 4 comments

Comments

@lacion
Copy link

lacion commented May 23, 2013

right now its not possible to use date range queries.

@timestamp:date[20130522 TO 20130522]

this will be useful in cases where multi queries are being used to graph, i would like to have one query in some time range and the other with another time range.

like today and yesterday this would be really useful in comparing behaviors.

@rashidkpc
Copy link
Contributor

This is the proper format:
@timestamp:[2013-05-22 TO 2013-05-22]

@insasho
Copy link

insasho commented Sep 14, 2013

Is there syntax for constraining on clock time, too? For example, "only show me results with @timestamp between 10am and 11am today".

@siddharth
Copy link

Took me some time to figure it out but the following format works for me for searching entries between specific times (May 27 11am to 1130am to be exact)-

@timestamp:[1432704600000 TO 1432706400000]

Kibana requires timestamp in milliseconds from epoch format.

@julienbeclin
Copy link

Hello,

I am able to do this range filter using the Kibana @timestamp, but not able using my DateTime field (which is the one I use as my time field). The issue is that I have -4h using timestamp so instead of doing @timestamp:[now-7d/d TO now-7d/d] I have to do @timestamp:[now-7d/d-4h TO now-7d/d-4h] which is pretty ugly and boring.

Here is my DateTime format :

DateTime        June 18th 2015, 22:45:19.655

Any idea I could make it work with this field ? thanks

spalger pushed a commit to spalger/kibana that referenced this issue Mar 3, 2016
harper-carroll referenced this issue in harper-carroll/kibana Jul 11, 2016
This accompanies the shim in the Research area, generating the yaml config file and checking what was provided in the remapping file.
ari-aviran pushed a commit to ari-aviran/kibana that referenced this issue Feb 7, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

5 participants