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';更多推荐
发布评论