I'm using DataGrip inside PhpStorm to access MySQL database. From time to time I need to update datetime fields with current time. For example TablePlus has the option to set field value to now() and on save it populates it with current datetime. It would be nice to have something similar on DataGrip as it is my primary database editor and it is really annoying setting time by hand.
Maybe someone has a solution for this?
There is no way to achieve this at the moment. Here are 2 related feature requests on our tracker, please follow and vote: 'add NOW to datepicker', 'using functions in table editor'