Processing jdbc input formatted date field using date filter is giving extra slashes



I am reading from oracle table using jdbc plugin and I have a date field, which I am querying as formatted string using the statement;

SELECT field_a,field_b,field_c,TO_CHAR(date_field,'YYYY-MM-DDTHH24:MI:SS.ff3Z') AS date_field FROM my_table

This executes the query, but the output is like;

"date_field": "2017-06-09\\T\\06:53:00.357\\Z\\"

How can I make it like 2017-06-09T06:53:00.357Z?

(system) #2

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