Select Trump records .time()

Question

这就是我存储它们的方式

INSERT INTO Trump SET code='".$name."', type='cja', whendate='".time()."'

现在我想显示今天的记录。

SELECT * FROM Trump WHERE type='cja' AND DATE(whendate) = time(NOW()) ORDER BY points DESC LIMIT 5

为什么MySQL返回一个空的结果集？

Answer 1

INSERT INTO Trump SET code='".$name."', type='cja', whendate='".strtotime(Date('Y-m-d')."'

然后尝试sql select命令

SELECT * FROM Trump WHERE type='cja' AND whendate ='".strtotime(Date('Y-m-d')."' ORDER BY points DESC LIMIT 5

将选择今天插入的所有记录。