Sql_last_value and implicit time zoned data

Elastic Stack Logstash
1

Hi all,

MySql server is UTC : now() give UTC date .
sql_last_value is stored in UTC in file ( from MySQL ? )
But data I have to compare to sql_last _value are locale date as string.
I can't use CONVERT_TZ with named zone because time zone tables are not available.
I can't use CONVERT_TZ with explicite value because it's not constant in time ( summer/winter offset )
I 'm not sure that jdbc_default_timezone or plugin_timezone can help me.
Have someone an idea please ?

2

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