Hello
I am facing alot of issues with Date time format.
Here is actual data into CSV file as below.
04/13/2016 04:20:39
04/13/2016 04:21:05
Elastic search template format for field as below to support date.
"server_timestamp": {
"type": "date",
"format": "MM/dd/yyyy HH:mm:ss"
}
Logstash
date {
locale => "en"
match => [ "server_timestamp" , "MM/dd/yyyy HH:mm:ss" ]
}
Kibana format looks as below,
_source
Path:
Table format looks: server_timestamp: April 12th 2016, 22:56:49.000
JSON format looks: "server_timestamp": "04/13/2016 04:56:49",
I am not sure why server_timestamp into Table format and JSON format are different.
Data imported successfully and i can view it into kibana, but when i apply filter from Kibana visualization, i got below error.
Visualize: failed to parse date field [1460525820000] with format [MM/dd/yyyy HH:mm:ss]
Can you please let me know that which constant Datetime format i need apply,
Thanks for your help in advance,
Sam