MySQL DATETIME类型和Timestamp之间的转换

MySQL DATETIME类型和Timestamp之间的转换

DATETIME -> Timestamp: UNIX_TIMESTAMP(...)

Timestamp -> DATETIME: FROM_UNIXTIME(...)

mysql> SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()));

+--------------------------------------+

| FROM_UNIXTIME(UNIX_TIMESTAMP(NOW())) |

| 2011-11-22 09:27:41                  |

本文转自 holy2009 51CTO博客，原文链接:http://blog.51cto.com/holy2010/721706