mysql> insert into foo values("20011023083000"); Query OK, 1 row affected (0.01 sec) mysql> insert into foo values("2001-10-24 12:24:00"); Query OK, 1 row affected (0.00 sec) mysql> select * from foo; +----------------+ | dt | +----------------+ | 20011024122400 | | 20011023083000 | +----------------+ 2 rows in set (0.01 sec)