Unix Timpstamp

1. 普通时间字段 --> Unix-Timestamp

SELECT UNIX_TIMESTAMP(NOW());

 

 

2. Unix-Timestamp --> 普通时间字段

SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()));