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