Dateparse failure jdbc

[karlm (karl)]

i have an datetime column from sql and trying to map it to the @timetsamp field but receiving date parse error

sql column

date
2020-03-24 11:44:03.000

filter

filter{
  date {
      match => [ "date", "yyyy-MM-dd HH:mm:ss.SSS" , "ISO8601"]
      target => "@timestamp"
  }   
}

result

"_source": {
        "date": "2020-03-10T09:35:37.000Z",
        "@timestamp": "2020-04-01T13:10:52.064Z",
        "tags": [
         "_dateparsefailure"
        ]
     }

any help please?

[Badger]

If the column is a date in the database the jdbc filter will have converted it into a LogStash::Timestamp. You should mutate+convert it to a string before calling a date filter.