-- 假设 1164691264437 是 Java 里的“日期时间”:即:自1970-01-01 00:00:00以来的毫秒数
/*
getTime
public long getTime()Returns the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this Date object.
Returns:the number of milliseconds since January 1, 1970, 00:00:00 GMT represented by this date.*/mysql> select from_unixtime(1164691264437/1000);+-----------------------------------+| from_unixtime(1164691264437/1000) |+-----------------------------------+| 2006-11-28 13:21:04 |+-----------------------------------+1 row in set (0.05 sec)