mysql - 轉換欄位日期為時間戳記

Answer 1

UPDATE xxx set 欄位 = UNIX_TIMESTAMP(欄位)

Answer 2

Reference: http://www.cnblogs.com/Bright...
Probably use

SELECT UNIX_TIMESTAMP('2016-01-20 20:09:10')