SQL Between a and b

注意：

SQL语句 Between a and b ，a/b的数据:a<b,否则查询不出来。

SELECT     COUNT(1) AS Count
FROM         dbo.Orders
WHERE     (order_date BETWEEN '2017 / 1 / 1' AND '2017 / 7 / 1')

　　

SELECT     COUNT(1) AS Count
FROM         dbo.Orders
WHERE     (order_date BETWEEN '2017 / 7 / 1' AND '2017 / 1 / 1')

　　

 

Which one can ingore order?