Date format not accepted by ES

[Vineeth-Mohan]

While using Kibana , i am facing this issue.
The request is going from Kibana as
{"range":{"TimeStamp":{"from":"2013-05-03T02:12:24.043Z","to":"2013-05-03T08:12:24.044Z"}}}

But timestamp in ES is in another format as told in index meta (dd-MM-yyyy HH:mm:ss)

Due to this am getting a

× Oops! TransportSerializationException[Failed to deserialize exception response from stream]

There should be some option to edit the timestamp format

[rashidkpc]

Can you post your elasticsearch mapping? ISO8601 date ranges should work regardless of the stored format as long as you're storing the field as a date object:

curl -XGET 'http://localhost:9200/_mapping?pretty'

[Vineeth-Mohan]

Mapping - https://gist.github.com/Vineeth-Mohan/5525521
Field in question -

"TimeStamp" : {
"type" : "date",
"format" : "dd-MM-yyyy HH:mm:ss"
},

[Vineeth-Mohan]

Hello @rashidkpc
Thanks for taking time to look into my issue. Yes , i use standard date object to store all the date objects. I believe that is the right way to do it. Let me know if there is some unconventional method i have followed.

[rashidkpc]

This should allow for you to store in one format, but query in the standard ISO8601 format.

"TimeStamp" : {
"type" : "date",
"format" : "dd-MM-yyyy HH:mm:ss||yyyy-MM-dd'T'HH:mm:ss.SSSZZ"
},

[Vineeth-Mohan]

Hello @rashidkpc - This would mean i have to reindex the whole index just for sake of kibana. And i believe there would be more users who will use the date type. So would it be very hard to specify the date format , may be in config.js

[steveblackmon]

+1 there are many date types in common use and standard way of using is to map directly in the type or use dynamic which just applies the first match and then the standard types no longer understood