我如何按天计算数据
本文关键字:数据 计算 何按天 | 更新日期: 2023-09-27 18:27:10
我喜欢count job_id
js_id int
job_id int
apply_date smalldatetime
代码:
string cmdstr3 = "SELECT COUNT(job_id) FROM applied_jobs
WHERE js_id='" + jsId + "' AND apply_date='" + DateTime.Now.Date + "'";`
string cmdstr4 = "SELECT COUNT(job_id) FROM applied_jobs
WHERE js_id='" + jsId + "' AND (apply_date >='" + start_date.Date + "' AND apply_date <'" + end_date.Date+ "')";
但它算作0
我有这样的数据
3/6/2012 12:00:00 AM
3/6/2012 12:00:00 AM
3/5/2012 12:00:00 AM
您似乎想要获得某个js_id
的当前日期的条目计数。以下是您应该做的简单操作:
var cmd = new SqlCommand("SELECT COUNT([job_id]) FROM [applied_jobs] WHERE [js_id] = @jsid AND datediff(day,[apply_date], @applydate) = 0",cn);
cmd.Parameters.Add("@jsid", SqlDbType.Int).Value = jsId;
cmd.Parameters.Add("@applydate", SqlDbType.SmallDateTime).Value = DateTime.Now.Date;