mysql> Select UNIX_TIMESTAMP();

-> 882226357

mysql> Select UNIX_TIMESTAMP(’1997-10-04 22:23:00′);

-> 875996580

mysql> Select FROM_UNIXTIME(875996580);

-> ’1997-10-04 22:23:00′

Published in MySQL

No Responses to “mysql中日期与时间戳的相互转换”

Leave a Reply

请输入算式结果(看不清请点击图片)
(必须)