I am importing a MS SQL table with a datetime column. It makes stored values of this type: 2008-02-18 00:00:00.000 2009-04-28 00:00:00.000 2000-05-03 00:00:00.000 ... by default jdbc input plugin does not detect this column type as a date but as text , so I am trying to use date filter to co…

Okay, so the field contains a java.sql.Timestamp object. Then you can use a ruby filter to convert it, e.g. to an epoch value that the date filter understand. This probably works: ruby { code => "event.set('[@metadata][epoch]', event.get('date_visa_demande').getTime)" } date { match => ["[@meta…

MSSQL datetime column parsing good format mapping and good date filter?

Elastic Stack Logstash

Lemec_Cinq (Lemec Cinq) January 16, 2017, 3:35pm 4

First thank you for your answere .
sorry for the column name it was a mistake, i fixed it.

So What should i write in filter to target a mssql datetime column called "date_visa_demande"?
I am a beginner and i don't see really how it works

Topic		Replies	Views
Jdbc plugin: how to make a date convertion for a column? Logstash	5	1999	February 6, 2017
Datetime from sql to Timestamp logstash Logstash	25	11961	March 7, 2018
Logstash - set @timestamp from sql date column with JDBC input Logstash	4	4289	September 1, 2017
Dateparse failure jdbc Logstash	2	249	April 29, 2020
Error using date match filter Logstash	5	1998	July 6, 2017

MSSQL datetime column parsing good format mapping and good date filter?

Related topics