> For the complete documentation index, see [llms.txt](https://huataihuang.gitbook.io/cloud-atlas-draft/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://huataihuang.gitbook.io/cloud-atlas-draft/database/mysql/sql/select_date_equal_to_today.md).

# 查询当天数据

> MySQL支持查询日期格式类似shell的`date +%Y%m%d`这样的方法，所以就很容易对比时间：

```sql
SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
FROM users 
WHERE DATE(signup_date) = CURDATE()
```

或者

```sql
SELECT users.id, DATE_FORMAT(users.signup_date, '%Y-%m-%d') 
FROM users 
WHERE DATE_FORMAT(users.signup_date, '%Y-%m-%d') = CURDATE()
```

## 参考

* [MySQL Select Date Equal to Today](https://stackoverflow.com/questions/12677707/mysql-select-date-equal-to-today)