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

**URL:** <https://discuss.elastic.co/t/processing-jdbc-input-formatted-date-field-using-date-filter-is-giving-extra-slashes/136607>\
**Category:** Logstash\
**Created:** [June 20, 2018, 5:03am UTC](https://discuss.elastic.co/t/processing-jdbc-input-formatted-date-field-using-date-filter-is-giving-extra-slashes/136607 "2018-06-20T05:03:18Z")\
**Posts on this page:** 2\
**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:** [June 20, 2018, 5:03am UTC](https://discuss.elastic.co/t/processing-jdbc-input-formatted-date-field-using-date-filter-is-giving-extra-slashes/136607/1 "2018-06-20T05:03:18Z")

</div>

Hi,

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`?

---

<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 18, 2018, 5:03am UTC](https://discuss.elastic.co/t/processing-jdbc-input-formatted-date-field-using-date-filter-is-giving-extra-slashes/136607/2 "2018-07-18T05:03:38Z")

</div>

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