mysql转换13位unix时间,如何在Mysql中将人的日期转换为unix时间戳？

I have a table with a date field, having human date in it like: '2008-01-08 19:23:32'

Now i have to copy this field plus some other fields of the same table to another table, but date needs to be in unix timestamp.

Is there any function in mysql which converts human date to unix timestamp inside query itself?

解决方案

mysql> select unix_timestamp('2008-01-08 19:23:32');

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

| unix_timestamp('2008-01-08 19:23:32') |

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

| 1199849012 |

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

1 row in set (0.04 sec)