我如何获得今天日期的mysql结果? [英] how do i get mysql results of todays date?

问题描述

我正在尝试从今天插入的表中提取结果.每个插入都标有时间戳.

I'm trying to pull results from a table that have been inserted today. Each insert is marked with a timestamp.

如果我做这样的查询:

SELECT * 
  FROM table 
  WHERE added > DATE_SUB(NOW(), INTERVAL 1 DAY) 

我似乎收到了今天日期的内容，但也收到了 24 小时前的内容.也许我在看东西.

It seems I get stuff that did fall on today's date, but also stuff from 24 hours ago. maybe I'm seeing things.

我不想看到 24 小时前的东西...

I don't want to see stuff from 24 hours ago...

推荐答案

您可以提取时间戳字段的日期部分并将其与当前日期.

SELECT x,y,z FROM t WHERE Date(added)=Curdate()

这篇关于我如何获得今天日期的mysql结果?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！