mysql怎么忽略小数_如何忽略MySQL 5.6的小数秒？

MySQL 5.6.4及更高版支持时间列类型的小数秒.

http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html

但我想忽略小数秒部分的兼容性.

mysql> CREATE TABLE `t1` (`created` datetime(0) NOT NULL);

Query OK, 0 rows affected (0.41 sec)

mysql> INSERT INTO t1 set created = '2013-08-27 05:13:21.999';

mysql> INSERT INTO t1 set created = '2013-08-27 23:59:59.999';

mysql> select * from t1;

+---------------------+

| created |

+---------------------+

| 2013-08-27 05:13:22 |

| 2013-08-28 00:00:00 |

+---------------------+

2 row in set (0.00 sec)

预期结果为’2013-08-27 05:13:21’和’2013-08-27 23:59:59′.

如何在以前版本的MySQL中保存相同的结果？