mysql 毫秒进位

import java.time.LocalDateTime;
import java.time.ZoneId;
import java.time.format.DateTimeFormatter;

public class TimestampExample {
    public static void main(String[] args) {
        LocalDateTime now = LocalDateTime.now();
        long epochMilli = now.toInstant(ZoneId.systemDefault()).toEpochMilli();
        System.out.println("Epoch Milli: " + epochMilli);

        // 插入数据库时，确保毫秒部分正确进位
        String formattedDateTime = now.format(DateTimeFormatter.ofPattern("yyyy-MM-dd HH:mm:ss.SSS"));
        System.out.println("Formatted DateTime: " + formattedDateTime);
    }
}

DELIMITER $$
CREATE TRIGGER before_insert_timestamp
BEFORE INSERT ON your_table
FOR EACH ROW
BEGIN
    SET NEW.timestamp_column = FROM_UNIXTIME(UNIX_TIMESTAMP(NEW.timestamp_column) * 1000);
END$$
DELIMITER ;