SnippetsSnippets
mysql1Clear
MySQL timestamp formatter

Create a function called h which formats a unix timestamp in a human readable format.

DELIMITER $$

CREATE FUNCTION h(ms BIGINT)
RETURNS DATETIME
DETERMINISTIC
BEGIN
    RETURN FROM_UNIXTIME(ms / 1000);
END$$

DELIMITER ;