我写了代码,但我可以得到所有的日期。如何获取当前月份的日期?
String connectionString = @"data source = localhost; initial catalog = StudentsBirthday; integrated security = SSPI;";
SqlConnection con = new SqlConnection(connectionString);
List<DateTime> birthdays = new List<DateTime>();
using (con)
{
con.Open();
SqlCommand cmd = new SqlCommand("Select Birthday From Students",con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
birthdays.Add(reader.GetDateTime(0));
}
}
foreach (DateTime Birthday in birthdays)
{
Console.WriteLine(Birthday);
}
Console.ReadKey();
您可以使用此 SQL 查询:
SELECT Birthday FROM Students
WHERE MONTH(Birthday) = MONTH(GETDATE())
ORDER BY Birthday
这将比较生日月份和GETDATE()
函数中的当前月份。这将按(升序)日期对生日进行排序。
您可以将其添加到您的代码中,如下所示:
var sqlQuery = "SELECT Birthday FROM Students WHERE MONTH(Birthday) = MONTH(GETDATE()) ORDER BY Birthday"
SqlCommand cmd = new SqlCommand(sqlQuery,con);
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句