废话不说,直接看代码吧:
SELECT uname, FROM_UNIXTIME( datex, '%Y-%m-%d' ) FROM `datex` WHERE FROM_UNIXTIME( datex, '%Y%m%d' ) =20120711
SELECT uname, FROM_UNIXTIME( datex, '%Y-%m-%d' ) FROM `datex` WHERE FROM_UNIXTIME( datex, '%Y%m%d' ) =20120711