Hello Reader's if you are using unix timestamp for storing date the time. Then you have to convert them into date format. But now MySql has come with a new syntax of 'format', Because of this it will ...

//create table CREATE TABLE `testdate` ( `product` varchar(255) DEFAULT NULL, `tanggal` timestamp NOT NULL DEFAULT current_timestamp() ) //insert INSERT INTO testdate (product) VALUES ("ki"); Yang ...

The new option "use native date/time format" does not work fully correctly with MySQL, where I get a trailing .0: DBeaver shows 2018-08-21 18:33:03.0 instead of 2018-08-21 18:33:03 for a DATETIME ...