之前使用mysql存储日期类型的数据用datetime,timestamp,现在把它存为int，对于表的数据量比较大的话，这样节省空间

看下面表字段

看下查询语句<??http://www.2cto.com/kf/ware/vc/" target="_blank" class="keylink">vcD4KPHA+U0VMRUNUIHVwdGltZSxGUk9NX1VOSVhUSU1FKHVwdGltZSkgRlJPTSBxbG1fdXJsYnJpZGdlcyA8YnI+CjwvcD4KPHA+PGltZyBzcmM9"https://www.cppentry.com/upload_files/article/57/1_mwvb1__.jpg" alt="\">

2.SELECT uptime,FROM_UNIXTIME(uptime) FROM qlm_urlbridges WHERE uptime>UNIX_TIMESTAMP("2015-06-01 00:00:00')

3.java把日期转换

Integer itg = Integer.valueOf(Long.valueOf(new Date().getTime() / 1000).toString());