msyql DATETIME类型和Timestamp之间的转换

DATETIME -> Timestamp: UNIX_TIMESTAMP(...)

Timestamp -> DATETIME: FROM_UNIXTIME(...)

select date_of_establishment,FROM_UNIXTIME(UNIX_TIMESTAMP(date_of_establishment)) as date_of_establishment2 from web_crawler.for_xun_cha