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
UTC time zome support for date/ time input from HeidiSQL
Code modification/commit
7d3b727
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
Please login to leave a reply, or register at first.