Missing time for Oracle db
senalkularatne opened this issue · 0 comments
senalkularatne commented
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>