sql - 日期过滤器查询不工作

Question

@SQL = "SELECT * from User WHERE LoginDate Between '2019-10-21' AND '2019-10-31'"

如何在此查询中添加日期范围？

标签： sql

Answer 1

你可以这样做。

 @SQL = "SELECT * from User WHERE LoginDate >= '2019-10-21' AND  LoginDate <= '2019-10-31'"