Hi All i am using logstash to index document from MSSQL server to elasticsearch, i am using below config file in order to do an incremental indexing, for that i am using using column called modified_date but having problem with dateformat. input { jdbc { jdbc_driver_library => "D:/Users/xxxxx/Deskt…

@Mohan_vel Is the variance between your source data (in sql table) and the sql_last_value reflects same as the variance between your timezone and the UTC? if so, as workaround you can consider that within statement. or you may use the additional parameter jdbc_default_timezone

Discuss the Elastic Stack

Sql_Last_Value date format seems to be irrelevant

Elastic Stack Logstash

Badger February 4, 2020, 5:02pm 2

SQL Server supports ISO 8601 date formats. What makes you think this is not working?

1 Like

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.