Re: Why _timestamp field is not returned with the format that we have set in the mapping?

2015-03-25 Thread Lee Chuen Ooi
Hi Mark, Here is my query. The result returned is not in UTC, still in unix epoch. Do you know why? *Query run in Sense:* GET _search?fields=_timestamp,_source { "query": { "match_all": {} } } *Result:* "fields": { "_timestamp": 1427177681930

Re: Why _timestamp field is not returned with the format that we have set in the mapping?

2015-03-24 Thread Mark Walkom
ES stores timestamps as unix epoch under the hood, however it will translate that to UTC when you request it. On 25 March 2015 at 15:47, Lee Chuen Ooi wrote: > Hi, > I want to make use of the _timestamp field to keep track the last indexed > datetime of an doc in ElasticSearch. > I have set the

Why _timestamp field is not returned with the format that we have set in the mapping?

2015-03-24 Thread Lee Chuen Ooi
Hi, I want to make use of the _timestamp field to keep track the last indexed datetime of an doc in ElasticSearch. I have set the mapping as below: "mappings": { "_default_": { "_timestamp": { "enabled": true, "store": true,