MySQL“之间"条款不包括在内? [英] MySQL "between" clause not inclusive?

问题描述

如果我使用between子句运行查询，则似乎排除了结束值.
例如:

If I run a query with a between clause, it seems to exclude the ending value.
For example:

select * from person where dob between '2011-01-01' and '2011-01-31'

这将获得从'2011-01-01'到'2011-01-30'的所有dob结果；跳过dob为'2011-01-31'的记录.谁能解释这个查询的行为方式，以及如何修改它以包含dob为'2011-01-31'的记录? (由于用户选择了结束日期，因此未在结束日期前加上1.)

This gets all results with dob from '2011-01-01' till '2011-01-30'; skipping records where dob is '2011-01-31'. Can anyone explain why this query behaves this way, and how I could modify it to include records where dob is '2011-01-31'? (without adding 1 to the ending date because its been selected by the users.)

推荐答案

字段dob可能具有时间分量.

The field dob probably has a time component.

将其截断:

select * from person 
where CAST(dob AS DATE) between '2011-01-01' and '2011-01-31'

这篇关于MySQL“之间"条款不包括在内?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！