Not able to parse time column in DB table


(Anirban Sen) #1

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.


(Magnus B├Ąck) #2

"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.


(system) #3

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.