"This is a UNIX timestamp column" timezone

[Allineer]

Is your feature request related to a problem? Please describe.

"This is a UNIX timestamp column" always use a local timezone. No ability to see timestamps in different timezone, e.g. UTC.

Describe the solution you'd like

Please, use the SELECT @@session.time_zone; query result as timezone value when converting a UNIX timestamp column values.

[ansgarbecker]

Please don't cross post things in the forum and here.

Apart from that, displaying timestamps in the server's timezone makes sense I suppose. There is even already the opposite option in the session manager's advanced tab. Activating it currently tells HeidiSQL to fire SET time_zone='+02:00':

It probably makes sense to format UNIX timestamps like now when that checkbox is checked, and with the server's timezone if unchecked.

[Allineer]

@ansgarbecker, I'm sorry. I learned about the GitHub repository today only and decided that this is a better place for my issue.

It probably makes sense to format UNIX timestamps like now when that checkbox is checked, and with the server's timezone if unchecked.

Yes, this is a good solution, but not sufficient.

It turns out that we have only two options available - either the server's time zone or the client's time zone.

It is often useful to work with data in the time zone of the target users of the application - this can be the third time zone.

In this case, I use the "Startup script" with this query: SET time_zone='+09:00', but this does not work now and will not work in the future with timestamp columns in case of your solution.