# Convert type to timpestamp

**URL:** <https://discuss.elastic.co/t/convert-type-to-timpestamp/91289>\
**Category:** Logstash\
**Created:** [June 29, 2017, 1:41pm UTC](https://discuss.elastic.co/t/convert-type-to-timpestamp/91289 "2017-06-29T13:41:18Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mohammed\_cherif](https://avatars.discourse-cdn.com/v4/letter/m/c89c15/32.png) [@mohammed\_cherif](https://discuss.elastic.co/u/mohammed_cherif)\
**Post date:** [June 29, 2017, 1:41pm UTC](https://discuss.elastic.co/t/convert-type-to-timpestamp/91289/1 "2017-06-29T13:41:18Z")

</div>

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 🙂

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 27, 2017, 1:41pm UTC](https://discuss.elastic.co/t/convert-type-to-timpestamp/91289/2 "2017-07-27T13:41:29Z")

</div>

Closed on July 27, 2017, 1:41pm UTC

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