mysql字符串转时间函数显示到毫秒,如何在MySQL中将秒（或毫秒）转换为时间戳（或只是一个看起来像日期的字符串）...

I'm looking at this documentation

http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_maketime

And I KNOW I must be missing it, but I just don't see a function here that I can pass seconds (or milliseconds) to, and get back either a Timestamp, or just a string representing the date.

Please help.

解决方案

If you are working with seconds since 1970 (i.e. Unix timestamps then FROM_UNIXTIME()) could well be what you want.

FROM_UNIXTIME Returns a representation of the unix_timestamp argument as a value in

'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is

used in a string or numeric context.

The value is expressed in the current time zone. unix_timestamp is an internal timestamp value such as is produced by the UNIX_TIMESTAMP() function.