Hi, is it possible to filter query inside jdbc input by CURRENT_DATE? I have the following config: input { jdbc { statement => "SELECT userId, timestamp FROM users;" schedule => "* * * * *" tags => ["kpi"] } } I'd like to change it to: input { jdbc { stateme…

It's a much better idea to do this in the SQL by using TRUNC(sysdate). Oracle TRUNC Date Function By Practical Examples This tutorial shows you how to use Oracle TRUNC() function to truncate a date to a specified unit and gives you some practical examples. Est. reading time: 2…

Discuss the Elastic Stack

Current date jdbc plugin

Elastic Stack Logstash

Badger July 26, 2021, 5:12pm 8

See also here.

Topic		Replies	Views
How to add a date filter statement into JDBC input? Logstash	3	353	January 14, 2020
Logstash - set @timestamp from sql date column with JDBC input Logstash	4	4229	September 1, 2017
How to express today's date in sql in logstash Logstash	2	388	March 15, 2019
Logstash timestamp issue - the log line date is one hour ahead the actual date Logstash	8	1201	September 6, 2020
_dateparsefailure for date filtering on database date column value Logstash	3	1075	May 9, 2017

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

Current date jdbc plugin

Related topics