MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE data(
 name VARCHAR(20),
 fecha INT
);
INSERT INTO data
VALUES
("alfred", UNIX_TIMESTAMP(NOW()));
SELECT * FROM data;


name
fecha


alfred
1535763759


SELECT name, FROM_UNIXTIME(fecha) FROM data;


name
FROM_UNIXTIME(fecha)


alfred
2018-09-01 02:02:39