In mapping a date field in an index, is it possible for Elasticsearch to treat a field containing data like this as a date field?
2015-07-14 18:42:26 America/Toronto
2015-07-14 22:42:26 UTC
I could not find an option for a time zone in the docs (https://www.elastic.co/guide/en/elasticsearch/reference/current/mapping-date-format.html). I am using a standard Joda Time Zones, though (http://joda-time.sourceforge.net/timezones.html).
If the time zone cannot be taken into account, then can the remaining date (such as only 2015-07-14 18:42:26) still be salvaged without the time zone?
And I also have a few fields that represent are in a unix epoch date format:
I want to be able to map these in Kibana and plot data according to these dates, but I cannot seem to get the correct format in my index mappings. Is this possible with the built in mappings, or do I need to go for a custom mapping? (The docs seem to suggest that time zone's are not parsed and all date formats are treated as UTC.)