本文介绍了MySQL“之间"条款不包括?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
如果我使用 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“之间"条款不包括?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！
本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除！