Not able to parse time column in DB table

[anisen (Anirban Sen)]

Hi,

I am trying to parse the data from a Oracle DB table with has a column named ''executiontime", which I want to use to plot the graphs.

Value of the column is like : 21-MAY-18 04.24.29.000000000 AM -05:00

using the below filter but getting dateparsefailure:

filter{
date {
match => ["executiontime", "ISO8601"]
}
}

Kindly suggest.

[magnusbaeck (Magnus Bäck)]

"21-MAY-18 04.24.29.000000000 AM -05:00" is not a timestamp in ISO8601 format. Try a different date pattern, but see also https://github.com/logstash-plugins/logstash-filter-date/issues/95.