UTC time zome support for date/ time input from HeidiSQL

[expired user #8611]'s profile image [expired user #8611] posted 9 years ago in Feature discussion Permalink
Hello Ansgar,
I'd like to ask for an additional feature (for details see my attached screenshot):

"select now" returns UTC time if you have MySQL server running in UTC time zone.
This is what's expected.

Contrary to this the local time is being offered, if you insert a date/ time into datetime or timestamp field using HeidiSQL GUI while using the same MySQL server (and session).
It would be very appreciated to have the chance to use the server time zone instead of the client (HeidieSQL) timezone.

Many thanks for your great software and best regards,
Lutz
1 attachment(s):
  • HeidiSQL-UTC-FeatureRequest
ansgar's profile image ansgar posted 9 years ago Permalink
Agree. HeidiSQL could fire a SELECT NOW() when the "Insert value" menu is expanded, and then use that date/time as base for all menu items.

Your screenshot looks as if you're not on the latest HeidiSQL version, are you?
[expired user #8611]'s profile image [expired user #8611] posted 9 years ago Permalink
I'm using version 9.1.0.4920 (64bit).
I though thos would be the latest one, isn't it?
1 attachment(s):
  • HeidiSQL-UTC-FeatureRequest2
ansgar's profile image ansgar posted 9 years ago Permalink
Current v9.2 release is from revision 4947. But the date/time value issue is the same in the current build.
Code modification/commit from ansgarbecker, 9 years ago, revision 9.2.0.4969
Use server time for data grid > "Insert value" menu items. See http://www.heidisql.com/forum.php?t=18717
ansgar's profile image ansgar posted 9 years ago Permalink
Done in r4969 - HeidiSQL now gets the server time per SELECT CURRENT_TIMESTAMP when you click on the "Insert value" submenu.
[expired user #8611]'s profile image [expired user #8611] posted 9 years ago Permalink
Great - many thanks!

Please login to leave a reply, or register at first.