Hi,
The timestamp of the event has timezone +05:00 specified, which translates
to 2015-03-09T19:00:00.000 when converted to UTC. As Elasticsearch uses UTC
internality default it looks to me that the result is correct as you have
not specified any timezone in the query.
Christian
On Tuesday, April 7, 2015 at 9:55:01 AM UTC+1, James Crone wrote:
>
> Hello!
>
> My query is this:
>
> GET _search
> {
> "query": {
> "bool": {
> "should": [
> {
> "range": {
> "DateTime": {
> "gt": "2015-03-01",
> "lte": "2015-03-09"
> }
> }
> }
> ]
> }
> }
> }
> Result is:
>
> {
> "took": 2,
> "timed_out": false,
> "_shards": {
> "total": 11,
> "successful": 11,
> "failed": 0
> },
> "hits": {
> "total": 1,
> "max_score": 1,
> "hits": [
> {
> "_index": "completedata",
> "_type": "users",
> "_id": "1",
> "_score": 1,
> "_source": {
> "ID": 1,
> "User_ID": 1,
> "Name": "Saudia Arabia Bomb",
> "Text": "Saudia Arabia Bomb",
> "Status": "online",
> "DateTime": "2015-03-10T00:00:00.000+05:00",
> "categories_ID": 1
> }
> }
> ]
> }
> }
>
> mapping for date is:
>
> "DateTime" : {
> "type" : "date",
> "format" : "dateOptionalTime"
> }
>
> It returns me the result of "2015-03-10".How can i get exact result by
> matching Date? Any Idea?
>
>
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to elasticsearch+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/elasticsearch/26d053f7-6c7a-41ec-a752-9bef6d1bf4e4%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
