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,
Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
UTC time zome support for date/ time input from HeidiSQL
LutzT posted 8 years ago in Feature discussion
Code modification/commit from ansgarbecker, 8 years ago, revision 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.