# Logstash-input-jdbc 如何对 statement 设置时间变量

**URL:** <https://discuss.elastic.co/t/logstash-input-jdbc-statement/98821>\
**Category:** 中文提问与讨论\
**Created:** [August 30, 2017, 8:51am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-statement/98821 "2017-08-30T08:51:09Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Moln](https://avatars.discourse-cdn.com/v4/letter/m/3ab097/32.png) [@Moln](https://discuss.elastic.co/u/Moln)\
**Post date:** [August 30, 2017, 8:51am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-statement/98821/1 "2017-08-30T08:51:09Z")

</div>

怎么设置让 input-jdbc 支持时间变量呢？

```auto
input {
  jdbc {
    #...
    statement => "select * from table_name_%{+yyyyMM}"
    #...
  }
}

```

---

<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:** [September 27, 2017, 8:51am UTC](https://discuss.elastic.co/t/logstash-input-jdbc-statement/98821/2 "2017-09-27T08:51:16Z")

</div>

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