sql-server - SQL 月度报告甚至在不同年份也显示

Question

我从我的数据库中获取访问者的月度报告，其中我有一个仅显示月份和年份（MM/yyyy）的日期时间选择器。代码正在工作，但问题是它即使在不同的年份也能工作。

var FirstDayOfMonth = new DateTime(dtpMonth.Value.Year, dtpMonth.Value.Month, 1);
var LastDayOfMonth = FirstDayOfMonth.AddMonths(1).AddDays(-1);
SqlCommand cmd = new SqlCommand("SELECT ISNULL(SUM(Male),0) as Male,ISNULL(SUM(Female),0)  as Female ,ISNULL(SUM(Pax),0)  as Pax,ISNULL(SUM(Single),0)  as Single,ISNULL(SUM(Married),0)  as Married,ISNULL(SUM(Students),0)  as Students,ISNULL(SUM(Elementary),0)  as Elementary,ISNULL(SUM(Highschool),0)  as Highschool, ISNULL(SUM(College),0)  as College,ISNULL(SUM(PWD),0)  as PWD, ISNULL(SUM([AR Users]),0)  as ARUsers,ISNULL(SUM([12 Below]),0)  as age1,ISNULL(SUM([13-21]),0)  as age2,ISNULL(SUM([22-35]),0)  as age3,ISNULL(SUM([36-50]),0)  as age4,ISNULL(SUM([51-65]),0)  as age5,ISNULL(SUM([65 Above]),0)  as age6 FROM  [tbl_Registration] where [Date Added] BETWEEN '"
        + FirstDayOfMonth.ToShortDateString() + "' AND  '" + LastDayOfMonth.ToShortDateString() + "'  ;", connection);

问题

如果我将年份更改为 09/2017，则输出与 09/2018 相同。我在加载数据之前清除标签，所以这不是问题。

标签： sql-server

Answer 1

更新 我太笨了！我日期的数据类型是 varchar。