Doesn't add value to database?

Question

PHP

Request directly to the database from the admin panel
INSERT INTO `day` SET `opentime`='1447776805'
Added 1 line. Inserted row identifier: 14 ( The request took 0.0869 sec. )
The opentime field has the TIMESTAMP type, I look in the database in the 0000-00-00 00:00:00 field, what's wrong?

Answer 1

https://dev.mysql.com/doc/refman/5.5/en/date-and-t...
And if you still need to store unixtime, then welcome to INT