1.查找某天记录(opTime为整形的时间戳)
Select onTime,FROM_UNIXTIME(opTime, '%Y%m%d') as myDay,FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), '%Y%m%d') as nowDay from log_loginout where FROM_UNIXTIME(opTime, '%Y%m%d') = FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), '%Y%m%d');
2.查找某月的记录
Select id,sum(onTime),FROM_UNIXTIME(opTime, '%Y%m') as myMonth,FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), '%Y%m') as nowMonth from log_loginout where FROM_UNIXTIME(opTime, '%Y%m') = FROM_UNIXTIME(UNIX_TIMESTAMP(NOW()), '%Y%m');