fluent/fluent-plugin-sql

Missing time for Oracle db

senalkularatne opened this issue · 0 comments

I'm using version 2.2.0 with oracle_enhanced as the adapter. What can I do to fix the date formatting when working with Oracle database.

For example 2017-12-20 01:33:20 shows up as 2017-12-20.

The config file looks something liker this:

<source>
  @type sql
  host xxxxxxx
  database xxxxxxx
  port xxxxxxx
  adapter oracle_enhanced
  username xxxxxxx
  password xxxxxxx

  select_interval 10s
  select_limit 5

  state_file ./sql_state

  <table>
    table abcd
    update_column created_date
    tag dblogs
  </table>
</source>

<match dblogs>
  @type stdout
</match>