mysql> create table dt2 (datum datetime, t tinytext);
Query OK, 0 rows affected (0.33 sec)

mysql> insert into dt2 (datum, t) values ('2006-01-02 12:00', 'b');
Query OK, 1 row affected (0.27 sec)

mysql> insert into dt2 (datum, t) values ('2006-01-01 12:00', 'a');
Query OK, 1 row affected (0.00 sec)

mysql> select * from dt2;
+---------------------+------+
| datum               | t    |
+---------------------+------+
| 2006-01-02 12:00:00 | b    |
| 2006-01-01 12:00:00 | a    |
+---------------------+------+
2 rows in set (0.00 sec)

mysql> select * from dt2 where datum="20060101120000";
+---------------------+------+
| datum               | t    |
+---------------------+------+
| 2006-01-01 12:00:00 | a    |
+---------------------+------+
1 row in set (0.00 sec)

mysql> 

+-------+---------------+------+-----+---------+-------+
| Field | Type          | Null | Key | Default | Extra |
+-------+---------------+------+-----+---------+-------+
| datum | timestamp(14) | YES  |     | NULL    |       |
| t     | tinytext      | YES  |     | NULL    |       |
+-------+---------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> select * from dt;
+----------------+------+
| datum          | t    |
+----------------+------+
| 20060403190617 | a    |
| 20060403190625 | b    |
+----------------+------+
2 rows in set (0.00 sec)

mysql> select * from dt where datum > '2006-04-03 19:06:20 ' ;
+----------------+------+
| datum          | t    |
+----------------+------+
| 20060403190625 | b    |
+----------------+------+
1 row in set (0.00 sec)

mysql> select date_format(datum, '%M %Y -- %r'), t from dt ;
+-----------------------------------+------+
| date_format(datum, '%M %Y -- %r') | t    |
+-----------------------------------+------+
| April 2006 -- 07:06:17 PM         | a    |
| April 2006 -- 07:06:25 PM         | b    |
+-----------------------------------+------+
2 rows in set (0.00 sec)