# Problem with logstash jdbc input plugin. Date field data is incorrect

**URL:** <https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682>\
**Category:** Logstash\
**Created:** [November 21, 2018, 10:35am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682 "2018-11-21T10:35:06Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![elasticheart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticheart/32/65189_2.png) [@elasticheart](https://discuss.elastic.co/u/elasticheart)\
**Post date:** [November 21, 2018, 10:35am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682/1 "2018-11-21T10:35:07Z")

</div>

Hi,

I am using ELK GA 6.3.0. I have the logstash configuration like below;

```
input {
  jdbc {
    jdbc_driver_library => "ojdbc6.jar"
    jdbc_driver_class => "Java::oracle.jdbc.driver.OracleDriver"
    jdbc_connection_string => "jdbc:oracle:thin:@127.0.0.1:1521:adminsid"
    jdbc_user => "user"
    jdbc_password => "pa$$word"
    statement => "SELECT START_TIME as timefield1, to_char(START_TIME, 'YYYY-MM-DD HH24:MI:SS:FF3') as timefield2 FROM mytable WHERE rownum <= 1"
  }
}

output {
  stdout {
    codec => rubydebug {
      metadata => true
    }
  }
}

```

I am getting the output as;

```
{
  "timefield1" => 2018 - 10 - 22T00: 55: 39.587Z,
  "@version" => "1",
  "timefield2" => "2018-10-22 06:25:39:587",
  "@timestamp" => 2018 - 11 - 21T09: 42: 23.204Z,
}

```

Everything except hour and minute are same. Why is there a difference in hour and minute, and how to fix this?

Thanks.

---

<div class="post-metadata">

**Author:** ![faulander](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/faulander/32/36344_2.png) [@faulander](https://discuss.elastic.co/u/faulander)\
**Post date:** [November 21, 2018, 10:58am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682/2 "2018-11-21T10:58:58Z")

</div>

... and the select gives you the correct values when directly run in the db?  
I don't think this is a logstash issue but a SQL "problem".

---

<div class="post-metadata">

**Author:** ![elasticheart](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/elasticheart/32/65189_2.png) [@elasticheart](https://discuss.elastic.co/u/elasticheart)\
**Post date:** [November 21, 2018, 11:01am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682/3 "2018-11-21T11:01:00Z")

</div>

When i run the query in SQL console or SQL developer, the results are coming correct. That's why i wonder.

---

<div class="post-metadata">

**Author:** ![faulander](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/faulander/32/36344_2.png) [@faulander](https://discuss.elastic.co/u/faulander)\
**Post date:** [November 21, 2018, 11:05am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682/4 "2018-11-21T11:05:00Z")

</div>

this is strange. It cannot be a timezone issue, because then only the hours should be different.  
I am out, i am not experienced with the jdbc plugin.

---

<div class="post-metadata">

**Author:** ![balumurari1](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/balumurari1/32/39203_2.png) [@balumurari1](https://discuss.elastic.co/u/balumurari1)\
**Post date:** [November 21, 2018, 11:08am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682/5 "2018-11-21T11:08:41Z")

</div>

Hello @elasticheart,

can you show me the sample date format, present in your database.

Regards,  
Balu

---

<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:** [December 19, 2018, 11:08am UTC](https://discuss.elastic.co/t/problem-with-logstash-jdbc-input-plugin-date-field-data-is-incorrect/157682/6 "2018-12-19T11:08:46Z")

</div>

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