# Sql\_last\_value and implicit time zoned data

**URL:** <https://discuss.elastic.co/t/sql-last-value-and-implicit-time-zoned-data/274797>\
**Category:** Logstash\
**Created:** [June 2, 2021, 7:23pm UTC](https://discuss.elastic.co/t/sql-last-value-and-implicit-time-zoned-data/274797 "2021-06-02T19:23:43Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![etva](https://avatars.discourse-cdn.com/v4/letter/e/b782af/32.png) [@etva](https://discuss.elastic.co/u/etva)\
**Post date:** [June 2, 2021, 7:23pm UTC](https://discuss.elastic.co/t/sql-last-value-and-implicit-time-zoned-data/274797/1 "2021-06-02T19:23:43Z")

</div>

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 ?

---

<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:** [June 30, 2021, 7:24pm UTC](https://discuss.elastic.co/t/sql-last-value-and-implicit-time-zoned-data/274797/2 "2021-06-30T19:24:03Z")

</div>

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