memo

memo dayo.

日時とUNIXTIMEの相互変換

-- datetime to unixtimestamp
SELECT UNIX_TIMESTAMP('2016-12-31 23:59:59');

-- unixtimestamp to datetime
SELECT FROM_UNIXTIME(1483196399);