Mysql Invalid datetime format: 1292 Incorrect datetime value
<pre><code>mysql&gt; describe taps;
+-------------+-------------+------+-----+-------------------+-------+
| Field       | Type        | Null | Key | Default           | Extra |
+-------------+-------------+------+-----+-------------------+-------+
| tag_id      | int(11)     | NO   |     | NULL              |       |
| time_stamp  | timestamp   | NO   |     | CURRENT_TIMESTAMP |       |
| device_id   | varchar(45) | YES  |     | NULL              |       |
| device_type | varchar(45) | YES  |     | NULL              |       |
+-------------+-------------+------+-----+-------------------+-------+

mysql&gt; INSERT INTO `taps` (tag_id, time_stamp) VALUES(0, 1451610061);
ERROR 1292 (22007): Incorrect datetime value: '1451610061' for column 'time_stamp' at row 1
</code></pre>

<p>WHY??  I have found many similar questions, but not of them seem quite this black and white.</p>

<p><code>1451610061</code> <strong><em>is</em></strong> a valid timestamp. I checked it at <a href="http://www.unixtimestamp.com/" rel="nofollow">http://www.unixtimestamp.com/</a> and it evaluates as expected.</p>

<p>So, why doesn't MySql like it?</p>