mysql> create table tstest( ts timestamp not null default now());
Query OK, 0 rows affected (0.03 sec)

mysql> insert into tstest values(from_unixtime(114454234));
Query OK, 1 row affected (0.00 sec)

mysql> select * from tstest;
+---------------------+
| ts                  |
+---------------------+
| 1973-08-17 17:50:34 |
+---------------------+
1 row in set (0.00 sec)