Create Unix Timestamp in MySQL

Question

How do I create a unix timestamp in MySQL? I know the type is set to INT and value is NULL but I need it to populate with current time in the format like: 1343782742

Answer 1

use UNIX_TIMESTAMP(date)

SELECT UNIX_TIMESTAMP(NOW())

• SQLFiddle Demo

• UNIX_TIMESTAMP