时间戳查询当天范围的数据
date(FROM_UNIXTIME(createAt, '%Y-%m-%d %H:%i:%s')) = CURDATE()
例:
SELECT * FROM q_company WHERE unitCode='FS001' AND windowId='31697c33848449e394fe29856aa20438' and date(FROM_UNIXTIME(createAt, '%Y-%m-%d %H:%i:%s')) = CURDATE() ORDER BY createAt DESC