mysql 时间格式化毫秒数

INSERT INTO your_table (timestamp_column) VALUES (UNIX_TIMESTAMP(NOW()) * 1000000 + MICROSECOND(NOW()));

SELECT 
    FROM_UNIXTIME(UNIX_TIMESTAMP(your_timestamp_column) / 1000000) AS formatted_time, 
    your_timestamp_column % 1000000 AS milliseconds 
FROM your_table;

DELIMITER $$

CREATE FUNCTION FORMAT_TIMESTAMP_MICRO(SECONDS BIGINT) RETURNS VARCHAR(26)
DETERMINISTIC
BEGIN
    DECLARE micros INT;
    SET micros = seconds % 1000000;
    RETURN CONCAT(FROM_UNIXTIME(seconds / 1000000), '.', LPAD(micros, 6, '0'));
END$$

DELIMITER ;

SELECT FORMAT_TIMESTAMP_MICRO(your_timestamp_column) AS formatted_time FROM your_table;