Convert type to timpestamp

Elastic Stack Logstash
1

i want to index data from table, i use this config :

input {
    jdbc {
        jdbc_connection_string => "jdbc:oracle:thin:@xxx:1512/yyy"
        jdbc_user => "test"
        jdbc_password => "test"
        jdbc_validate_connection => true
        jdbc_driver_library => "D:\logstash-5.4.0\jdbc\ojdbc6.jar"
        jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
        statement =>"select c.id as id, c.creatdate as creatDate, c.updatedate as updatedate, c.name as name, c.type as type from compte c " 
    }

	
}
output {
    elasticsearch {
        index => "collect-account-%{+YYYY.MM}"
        hosts => "localhost:9200"
    }
  stdout { codec => rubydebug }
}

But after creating the index-pattern in kibana i don't have the value of fields creatdate and updatedate

The type of creatdate and updatedate is TIMESTAMP(6) in oracle, so how can i specify in logstash the type timestimp ?

Example of date :
creatdate = 11/05/17 16:14:35,683000000

Thank's for help :slight_smile:

2

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