mysql> insert into datum (bestelldatum, expire) values (now(), adddate(now(), interval 1 year)); Query OK, 1 row affected (0.00 sec) mysql> select * from datum; +---------------------+---------------------+ | bestelldatum | expire | +---------------------+---------------------+ | 2007-11-21 12:39:48 | 2008-11-21 12:39:48 | +---------------------+---------------------+ 1 row in set (0.00 sec)