MySQL选择日期之间(MySQL Selection Date between)

MySQL选择日期之间(MySQL Selection Date between)

我有这个简单的mysql代码：

SELECT count(avs_id) as gesamtNat FROM sv_erfassung.erfasst WHERE DATUM between '2016-05-01' AND '2016-05-02' and rechtsform = 'natürliche Person';

Mysql给我零结果。 但这不可能如下所示

但如果我执行以下操作：

SELECT count(avs_id) as gesamtNat FROM sv_erfassung.erfasst WHERE DATUM between '2016-04-29' AND '2016-05-02' and rechtsform = 'natürliche Person';

MySql向我展示了24个结果。

所以有什么问题？

i have this simple mysql code:

SELECT count(avs_id) as gesamtNat FROM sv_erfassung.erfasst WHERE DATUM between '2016-05-01' AND '2016-05-02' and rechtsform = 'natürliche Person';

Mysql gives me zero result. But that can not be as you can see below

But if i trie the following:

SELECT count(avs_id) as gesamtNat FROM sv_erfassung.erfasst WHERE DATUM between '2016-04-29' AND '2016-05-02' and rechtsform = 'natürliche Person';

MySql shows me 24 results.

So whats the Problem?

最满意答案

您没有将时间与日期关联试试这个，

SELECT count(avs_id) as gesamtNat FROM sv_erfassung.erfasst WHERE DATUM between '2016-05-01' AND '2016-05-02 23:59:59' and rechtsform = 'natürliche Person';

You didn't associate time with date try this,

SELECT count(avs_id) as gesamtNat FROM sv_erfassung.erfasst WHERE DATUM between '2016-05-01' AND '2016-05-02 23:59:59' and rechtsform = 'natürliche Person';