SELECT * FROM myTable
WHERE DATEPART(year, tableDate)=DATEPART(year, @DATE) AND
DATEPART(month, tableDate)=DATEPART(month, @DATE) AND
DATEPART(day, tableDate)=DATEPART(day, @DATE)
供应作为一个参数的SqlCommand日期:
cmd.Parameters.AddWithValue("@DATE", new DateTime(2011, 9, 25));
评论会员:梅迪吴拉姆 时间:2012/02/06
要查询的日期列,你可以添加一个WHERE子句来查询日期:
string where = " where datecolumn between '"+date1+"' and '"+date2+"'";