mysql> SELECT UNIX_TIMESTAMP();
-> 1196440210
mysql> SELECT UNIX_TIMESTAMP('2007-11-30 10:30:19');
-> 1196440219
mysql> SELECT UNIX_TIMESTAMP('20071130103019');
-> 1196440219
mysql> SELECT UNIX_TIMESTAMP('1980-01-01');
-> 315507600