logstash mysql时间_Logstash jdbc 按时间增量更新的一些总结

不同数据库的支持

mysql数据类型显示样例是否支持timestampstatementtracking_columntracking_column_typeSQL示例date2020-10-20Nselect *, datediff(date, '1970-01-01') as days from tbl_time where datediff(date, '1970-01-01') > :sql_last_valuedaysnumericselect *, datediff(date, '1970-01-01') as days from tbl_time where datediff(date, '1970-01-01') > 1603244266

datetime timestamp2020-10-20 06:12:01Yselect * from tbl_time where time > :sql_last_valuetimetimestampselect * from tbl_time where time > '2020-10-20 06:12:01'

时间戳1603244266Yselect *, FROM_UNIXTIME(shjnch, '%Y-%m-%d %h:%i:%s') as timestamp from tbl_time where FROM_UNIXTIME(shjnch, '%Y-%m-%d %h:%i:%s') > :sql_last_valuetimestamptimestampselect *, FROM_UNIXTIME(shjnch, '%Y-%m-%d %h:%i:%s') as timestamp from tbl_time where FROM_UNIXTIME(shjnch, '%Y-%m-%d %h:%i:%s') > '2020-10-21 14:00:00'

sqlserve